On Mon, 2 Nov 2009 15:46:08 -0800, Donna wrote:

If you could help with this I would appreciate it.
I have 2 columns with initials.
Col A: will have initials
example Row 1 dcl, row 2 dcl, row 3 jah, row 4 peb, row 5, peb
Col B: is a constant list of possible initials
dcl, row, peb
I want to highlight in col A the initials if they are not lised in the
constant list in col b.
In the example I would want the cell in col a row 3 "jah" to be highlighed
since it was not listed in col b.
Thanks
Donna

Select A1
Conditional Format using the formula
=ISNA(MATCH(A1,$B$1:$B$3,0))

Format how you want it to look. E.g. Red fill with white font colors
stands out

Use format painter to copy format to the rest of the cells.

How you get into conditional formatting differs from Excel 2007 to previous.

In Excel 2007, you select Conditional formatting from the ribbon, then "New
Rule"; then "use a formula to determine which cells to format".

I don't recall exactly how to access this in the earlier versions.
--ron