y su
Start name-define ur refencelist as fx. List1 and List2
then select ur other list and insert this formula in cond.format
=COUNTIF(List1;A1) ' change A1 to ur first cell in the range
select color
select add
do the same just antoher color and user List2 here


"TonyR" skrev:

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