Highlihting duplicate entries

  • Thread starter Thread starter SiH23
  • Start date Start date
S

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.
 
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
 
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
 
Back
Top