Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare a cell to a range of cells?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare a cell to a range of cells?
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 On Jan 23, 1:50*am, 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare two Cells and highlight third cell | Excel Worksheet Functions | |||
how to compare 2 cells in range | Excel Worksheet Functions | |||
Compare two cells and return certain value in third cell | Excel Worksheet Functions | |||
compare cell with a range | Excel Discussion (Misc queries) | |||
How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions |