+ Reply to Thread
Results 1 to 4 of 4

Conditional Format a cell to turn red based upon the color of another cell.

  1. #1
    Registered User
    Join Date
    07-22-2019
    Location
    Missoula, MT
    MS-Off Ver
    10
    Posts
    4

    Conditional Format a cell to turn red based upon the color of another cell.

    I am working a spreadsheet and I need to have cell C2 and D2 red whenever cell B2 turns red. This won't apply to every cell in these columns, just a select few to identify issues.
    Cell B2 has the following conditional formatting "AND($C2="",$D2="")" if this occurs cell B2 turns red. Both of the previous conditions must occur, if one or the other does not occur B2 does not turn red and the line is correct. What I am trying to add in is to highlight C2 and D2 red if both come up as empty cells.

    Capture.JPG

    I"m not sure if this will require some VBA (not very familiar) or not.
    Last edited by rjmall0; 07-22-2019 at 09:05 PM. Reason: Solved.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,726

    Re: Conditional Format a cell to turn red based upon the color of another cell.

    If you select B2 and click on Conditional Formatting | Manage Rules you should see your rule defined there and in the Applies To section it will say $B$2 - just change this to $B$2:$D$2 (or you can make it $B$2:$D$100 if you have that much data), then click OK.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    07-22-2019
    Location
    Missoula, MT
    MS-Off Ver
    10
    Posts
    4

    Re: Conditional Format a cell to turn red based upon the color of another cell.

    I cannot believe it was that easy. I was looking much to far into this. Thank you Pete_UK

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,726

    Re: Conditional Format a cell to turn red based upon the color of another cell.

    You're welcome - thanks for the rep.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA to clear cell based on conditional format font color
    By jasonpbyu in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-14-2019, 03:50 PM
  2. Replies: 0
    Last Post: 04-04-2019, 08:59 AM
  3. Replies: 9
    Last Post: 06-23-2017, 12:59 PM
  4. [SOLVED] Conditional Format Based on Cell Color
    By morerockin in forum Excel General
    Replies: 3
    Last Post: 06-12-2016, 07:11 AM
  5. Replies: 8
    Last Post: 06-27-2015, 03:21 PM
  6. Conditional formating : turn color based on another cell value
    By selva120 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-18-2013, 02:29 AM
  7. Conditional format to change color of row based on data in cell
    By PJenkins in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-02-2013, 09:39 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1