Compare a cell to a range of cells?

  • Thread starter Thread starter Cam
  • Start date Start date
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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Finding Corresponding Cell Value 2
Conditional formatting help 3
Excel Visual Basic to get current row number 1
Excel Macro to automatically go to the right of the last colored cell 0
Conditional Format Range of Cells 3
Auto Fill a column 3
Conditional Format a range based on 1 cell 1

Back
Top