Select column B and add this formula in CF

=COUNTIF(D:D,B1)=0

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ken" wrote in message
...
Excel 2000 ...

Col B contains 1000 alpha-numerics (many repeat)

Col D contains 50 alpha-numerics (none repeat)

I would like "Conditional Formatting" Formula in Col B to
high-lite all alpha-numerics not found in Col D.

Thanks ... Kha