Changing colors of 1 cell from values of the entire row

Question

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......

lorenzo · Answer

Hi&nbsp;Tim_Byland&nbsp;&nbsp;&nbsp;With the above sample, Cond. Format rule&nbsp;Use a formula...&nbsp;that applies to $A$2:$A$5:=COUNTIF($B2:$G2, "x") = 6&nbsp;

Forum Discussion

Changing colors of 1 cell from values of the entire row

Share

Resources