Ok I have two columns:


A B
Customers: Prospects
Abc <highlightGhi<highlight
Def <highlightAbc<highlight
Ghi Tuv
Xyz
<highlightDef<highlight

I want to run a search against the customers in column A and to see if they
appear in the prospects column, if they do, I want to highlight them
automatically. It has to be done automatically because in the real list
there are about 140 customers and 4000+ prospects.

Thanks,

James