Checking entered data against exisitng data
 

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

Checking entered data against exisitng data
 

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



"TonyR" wrote in message
oups.com...
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