Conditional Formatting: Merged cell color

Solved/Closed
Ricky588 Posts 1 Registration date Friday April 11, 2014 Status Member Last seen April 11, 2014 - Apr 11, 2014 at 02:28 PM
 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

2 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Apr 14, 2014 at 11:08 AM
Hi Ricky,

Try this formula:

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


Best regards,
Trowa
0