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