Forum Discussion
Changing colors of 1 cell from values of the entire row
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....
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