View Single Post
  #1   Report Post  
David
 
Posts: n/a
Default

Ken wrote

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


If I understand what you mean by alph-numerics, how about:
Select Col B
Format|Conditional Formatting|Formula Is
=(COUNTIF(D:D,B1)=0)*ISTEXT(B1)
Choose color from Patterns

--
David