Highlihting duplicate entries

[SiH23]

I have column of names and would like to highlight all duplicate entries in
'blue' for example.

The entries run in Column C between row 2 and row 5000.

Any help or advice would be greatly appreciated.

 

[dernspiker]

I hope this is okay to say in this forum. I found wonderful add-in program
for free at ASAP Utilities. It does so many of these little things for you
with just the click of a button.

Dana

 

[PJ]

You can find a lot about dealing with duplicates, including the answer to
your question, here:

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

 

[Mike H]

Hi,

Select C2 then

Format|Conditional format - formula is
enter the formula

=COUNTIF($C$2:$C$500,C2)>1
Pick a colour and click OK

Use the format painter to copy the Cf to the rest of column C down to C500

Mike