Conditional Formatting based on another cell's contents

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

Do you want a row to highlight if there are more than one "x" such as in row 2 of your example?

Highlight C2:J13 > Conditional Formatting > New Rule > Use a formula

=AND(C2<>"x",COUNTIF($C2:$J2,"x"))

Format > Fill: Color of your choice > OK > OK

If you only want to highlight rows with exactly one "x", adjust the formula to this:
=AND(C2<>"x",COUNTIF($C2:$J2,"x")=1)

Originally Posted by 63falcondude

Do you want a row to highlight if there are more than one "x" such as in row 2 of your example?

No...this row is a bit different...only 1 cell in that row can be "X"'d so as soon as I "X" it, I want the rest to highlight so I don't mark the rest...

Originally Posted by 63falcondude

Highlight C2:J13 > Conditional Formatting > New Rule > Use a formula

=AND(C2<>"x",COUNTIF($C2:$J2,"x"))

Format > Fill: Color of your choice > OK > OK

If you only want to highlight rows with exactly one "x", adjust the formula to this:
=AND(C2<>"x",COUNTIF($C2:$J2,"x")=1)

Perfect thank you!!

You're welcome. Thanks for the rep!

If that solved your question, please mark this thread as SOLVED.