Conditional Formatting: Merged cell color [Solved/Closed]

Report
Posts
1
Registration date
Friday April 11, 2014
Status
Member
Last seen
April 11, 2014
-
 ricky588 -
Hi,

This is probably an easy solution but for the life of me cannot get this to work.

I have a situation whereby I have a line of information that may require several answers and this would be in the form of a merged cell with the outcome details and then several actions based on the outcome. In this situation I have 3 cells of information (G2:G4) and I would need the merged cell (B2:B4) to change color based on the same answer in G2:G4. So for example G2 says complete, G3 says complete and G4 says complete then the merged cell would turn green. In conditional format G column has been setup to say (Specific text-Containing-Complete=Green: Specific text-Containing-Needs Monitoring=Yellow: Specific text-Containing-Immediate Action=Red:

The conditional format in B2:B4 says the following: =G2:G4="Complete" format Green: =G2:G4="Needs Monitoring" format Yellow: =G2:G4="Immediate Action" format Red

If G2 says any of the options it turns the merged cell that color even if it says G2:G4.

Hopefully this makes sense.

Cheers,

Ricky

2 replies

Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
456
Hi Ricky,

Try this formula:

=COUNTIF(G2:G4,"Complete")=3


Best regards,
Trowa
Trowa,

Thank you so much!! It was an easy fix just did not think in that way.

Cheers,

Ricky

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!