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?

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?

Works ok for me.

When you do this there is a drop down where you can select either duplicate
or unique. Are you sure you selected duplicate?

--
Biff
Microsoft Excel MVP


"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?