I've attached a couple of photos...
I want the cells in C7:J7 to highlight IF one of the other cells has an X in it.
So if C7 has "X", I want D7:J7 to highlight
If D7 has "X", I want C7, and E7:J7 to highlight
I tried to create multiple single rules but it doesn't seem to be working. Is there a simple way to do this?
Conditional Formatting.JPG
Conditional Formatting2.JPG
Bookmarks