using conditional formatting to mark repeated names in list?

M

Mansure Morgan

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

Toppers

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
 
A

Ardus Petus

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
 
G

Gary''s Student

use conditional formatting:

formula is:

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

Then copy down
 
Top