Highlight all the data in column B, starting with cell B2, and click
on Format | Conditional Formatting and in the panel that pops up
select Formula Is in the first box rather than Cell Value Is. In the
second box enter this formula:

=COUNTIF(A$2:A$150,B2)0

then click the Format button, click on the Patterns tab, and then
choose your colour (eg bright yellow). Click OK twice to exit the
dialogue box, and then you should have what you want.

Hope this helps.

Pete

On Mar 14, 11:46*pm, Pete_UK wrote:
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- Hide quoted text -

- Show quoted text -