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