Assuming the range of column A is A1:A20 and the range of column B is
B1:B10. Also assuming no empty cells within either range.

Select the *entire* range A1:A20 starting from cell A1. Cell A1 will be the
active cell. The active cell is the one cell in the selected range that is
not shaded. The formula will be relative to the active cell.

Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=ISNA(MATCH(A1,B$1:B$10,0))
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"Donna" wrote in message
...
Please help with final piece to my worksheet

I have :
Col A : I have a list of all the divisions downloaded for that day (there
is
more than one line listed per division)
Col B I have a fixed list of certain divisions

What I would like is to highlight any div in Col A that was not listed
in
my fixed Col B
Thanks Donna