Compare a cell to a range of cells?

C

Cam

Hi,

Is there a way to put in a formula for conditional formatting to say change
the color of the text if cell A1 equal any of the value in the column AA?
Column AA has about 500 rows with value. The value is the a 6 numerical
digit. Thanks
 
P

Pete_UK

Is it the cells in column AA that you want to change colour if any of
them are equal to A1, or do you want A1 to change colour if it is
equal to any of the cells in the range AA1:AA500?

Pete
 
I

iliace

Hi,

Is there a way to put in a formula for conditional formatting to say change
the color of the text if cell A1 equal any of the value in the column AA?
Column AA has about 500 rows with value. The value is the a 6 numerical
digit. Thanks
Click to expand...

=COUNTIF($AA$1:$AA$500,A1)>0
 
Top