Conditional Formatting: Merged cell color [Solved/Closed]

Ricky588 1 Posts Friday April 11, 2014Registration date April 11, 2014 Last seen - Apr 11, 2014 at 02:28 PM - Latest reply:  ricky588
- Apr 14, 2014 at 12:22 PM
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
See more 

2 replies

TrowaD 2433 Posts Sunday September 12, 2010Registration dateModeratorStatus September 17, 2018 Last seen - Apr 14, 2014 at 11:08 AM
0
Thank you
Hi Ricky,

Try this formula:

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


Best regards,
Trowa
0
Thank you
Trowa,

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

Cheers,

Ricky