Formatting

T

Terry Boat

I need help with the below:

If the value in cell a1 has a corresponding value in Tabel c1:h15, then can
I change the color of cell a1 to blue?

-
Terry
 
G

Gary''s Student

click on a1 and:
Format > Conditional Formatting > Formula Is > =COUNTIF(C1:H15,A1)>0 and
pick the color
 
Top