how do i find cells that repeat the same content?

cdoyle · Sep 22, 2005

I want to find and highlight any cells that contain identical content.

Bob Phillips · Sep 22, 2005

Use conditional formatting with a formula of

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

adjust to suit your range