use conditional formatting:

formula is:

=COUNTIF($A$1:$A$65535,A1)1 and pick a distinctive format.

Then copy down
--
Gary's Student


"Mansure Morgan" wrote:

hi all
i would like to see which names in the list are being repeated, and i want
the repeated name to have different color, using conditional formatting.
anyone can help. i guess i can do it it by countif function, but how?