Check out Chip Pearson's web page on the subject:

http://www.cpearson.com/excel/Duplicates.aspx
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Johnson27" wrote in message
...
I have a column of data in which I'd like to have the duplicates
highlighted.
However, when I select this option from the Conditional Formatting
drop-down,
it incorrectly highlights non-duplicates as well. What is the logic
behind
identifying a "duplicate" and how can I prevent this error from occuring?