I'm not clear as to what you're looking for, but if you want any cell in
your range of data highlighted if it matches a list...

1) Select your data

2) Format Conditional Formatting Formula Is

3) Enter the following formula:

=MATCH(A1,$F$1:$F$5,0)

4) Choose your formatting

5) Click OK

...where A1 refers to the first cell in your range, and F1:F5 contains
the list to match.

On the other hand, if you want to highlight the whole row if the value
in Column A matches your list, then change the above formula to...

=MATCH($A1,$F$1:$F$5,0)

Hope this helps!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=276569