Checking entered data against exisitng data

[TonyR]

I have an excel spreadsheet that we use as an ongoing log of data,
within this data there is one specfic column that I want to check
against a list of data and I am wondering if this is possible?

Specifically, when the cell in this column is entered, can excel
check
that number against a set list of numbers within another row and turn
the background color of that cell a different color if the number
entered is found in the existing list of numbers in another row in
the
spreadsheet?


If this is possible, can it be checked against 2 lists of numbers,
returning a different color cell background depending on what list
(if
either) the number is found in?


Any help would be greatly appreciated,
Tony

 

[Tim]

Use conditional formatting with a formula something like this:

=NOT(ISERROR(MATCH(E20,$C$20:$C$25,0)))

Where in this case $C$20:$C$25 is the list of existing numbers and E20 is
the cell being formatted.

You can add up to 3 format conditions, each pointing to a different list and
having a different color.

Tim