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


"SiH23" wrote:

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.

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

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

"SiH23" wrote:

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.

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

"SiH23" wrote:

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.