Solved Highlighing Duplicates in Excel 2010

Microsoft Excel 2003 (full)
July 20, 2011 at 04:21:55
Specs: Windows XP, 1.0Gb
I have a list of several thousand numbers in one column. Using Conditional Formatting, I am able to identify and highlight duplicates, triplicates, etc.. However, this process highlights any matches. I need to highlight only the duplicate/triplicate, etc and not the original number.

Thank you.
Brian W

See More: Highlighing Duplicates in Excel 2010

July 20, 2011 at 07:04:54
✔ Best Answer
Try this as your Conditional Formatting formula:


Unfortunately, it's not one of my creations, "borrowed" it from Chip Pearson:


Report •

July 20, 2011 at 20:56:08
Why not just filter the column for unique values?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

July 26, 2011 at 11:48:21
Mmcconaghy and DerbyDad03,

Thank you for your responses; I tried the first approach before the second one was posted and it worked fine. I later tried the second approach and that also worked.

Brian W

Report •
Related Solutions

Ask Question