Let's assume this is your data:

A1: 12345
A2: 54321
A3: 12345

Which cell(s) should be highlighted?

--
Biff
Microsoft Excel MVP


"trvlpal" wrote in message
...
I create a column and when i put a phone number in I want to have it
indivcate if its a duplicate perferrable in red