* Select all(!) 2000 cells.
* Declare "Conditional Format" as per "Formula"
=COUNTIF($C$1:C1,C1)1
* declare some background color i order to identify the duplicate names.
*** This method will color from the second name and will not touch the first
one.
Micky


"John" wrote:

Is there a simple macro/VBA for checking a specific column in which there are
random duplicate text entries? I do not want to delete, remove or move them.
For example my Column C contains about 2000 song title entries some of which
are duplicates and I need to identify and tag them. I only need to ID them
for now. The simpler the better.
Thanks
--
John