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.