Forum Discussion
Conditional Formatting
I am trying to find a way to highlight one cell if there is an X in one of twelve cells. I have been using this rule =COUNTIFS($C$2:$E$2,"X") and it works great, but only for two cells. If I put mo...
=COUNTIF(B1:M1,"X")=1You can try this rule for conditional formatting.
=$N$1:$N$7This is the range the formatting applies to in my example.