You can apply conditionnal formatting to your whole list, using "Formula
is:"
=COUNTIF(A:A,A1)1

But that will apply the SAME formatting (eg: background color) to ALL
duplicates

HTH
--
AP

"Mansure Morgan" <Mansure a écrit dans le
message de news: ...
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?