Have you tried using Conditional Formatting on column B ?

Pete


On Mar 14, 11:38*pm, James wrote:
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