View Single Post
  #1   Report Post  
Ken
 
Posts: n/a
Default Conditional Format ... Compare Columns?

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