Compare a cell to a range of cells?
On Jan 22, 8:50*pm, Cam wrote:
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
|