Need help with Comparison Formula

[Colin]

Hi

I am tying to setup a spreedsheet which would have
multiple individual lists of phone numbers and i want to
be able to compare these lists to each other. Example
when a number in list A equals a number in list b then i
want this hightlighted. Is this possible.

Cheers


Colin (Dublin Ireland)

 

[Norman Harker]

Hi Colin!

Chip Pearson has a whole mass of formulas and code to handle most
things that you would want in this area.

See:
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates
And the rest of that page.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.