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?

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?

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?

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?