Try:

Formula is: =countif(a:a,a1)1 and set colour.

If a name is repeated then both (or more) occurences will be coloured.

HTH

"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?