=countif will highlight only unique records; however, I need one record of
each set of duplicates highlighted.

wondering why you need a color. I find pivot tables very useful when looking
for a duplicate. Drag names(or etc.) to the left and then drag names to the
Data and each duplicate will show as more than 1 count and then just filter
for Greater than 1...



"nirod" wrote:

=countif will highlight only unique records; however, I need one record of
each set of duplicates highlighted.

Use conditional formatting with a formula of

=COUNTIF($A$1:A1,A1)1

Select all the cells first, assuming A1 as first, and apply the CF.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"nirod" wrote in message
...
=countif will highlight only unique records; however, I need one record of
each set of duplicates highlighted.

How do I filter for x in a pivot?
--
Hile


"jenn" wrote:

wondering why you need a color. I find pivot tables very useful when looking
for a duplicate. Drag names(or etc.) to the left and then drag names to the
Data and each duplicate will show as more than 1 count and then just filter
for Greater than 1...



"nirod" wrote:

=countif will highlight only unique records; however, I need one record of
each set of duplicates highlighted.