Highlighting Duplicate Values in a column

[Flower R]

Hello!


In Column A, there are about 2000 plus entries, is there a simple formula to highlight the duplicate values in conditional format, so that the duplicate values stand coloured. Thanks.

[Flintstone]

Hello Flower R:

Here’s a web site that should help you out.

http://www.cpearson.com/Excel/Duplicates.aspx

Matt

[Raiby]

Hello!


In Column A, there are about 2000 plus entries, is there a simple formula to highlight the duplicate values in conditional format, so that the duplicate values stand coloured. Thanks.

Hi

With Excel 2007, Format|Conditional Formatting/Highlight Cells Rules/Duplicate Values