I need to change the color on Column A based on Columns B-G having the same value of "x" in them. I have been trying different formulas and nothing is working for me. Thanks in advance for your help.
- with the example below, I am trying to get "test 1" cell turn a different color since all columns in that row all have an "x"..
ANY HELP WITH THIS WOULD BE GREAT......
Hi @Tim_Byland
With the above sample, Cond. Format rule Use a formula... that applies to $A$2:$A$5:
=COUNTIF($B2:$G2, "x") = 6