Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Changing colors of 1 cell from values of the entire row

Copper Contributor

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

 

Tim_Byland_0-1706970437452.png

 

ANY HELP WITH THIS WOULD BE GREAT......

 

1 Reply

Hi @Tim_Byland 

 

Sample.png

 

With the above sample, Cond. Format rule Use a formula... that applies to $A$2:$A$5:

=COUNTIF($B2:$G2, "x") = 6