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.