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.
Conditional formatting merged cells
Excel conditional formatting merged cells - Best answers
Conditional formatting on merged cells - Best answers