Compare a cell to a range of cells?

[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

 

[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

 

[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

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