ExcelBanter - how do i find cells that repeat the same content?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do i find cells that repeat the same content? (https://www.excelbanter.com/excel-worksheet-functions/46723-how-do-i-find-cells-repeat-same-content.html)

cdoyle

how do i find cells that repeat the same content?

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

Bob Phillips

Use conditional formatting with a formula of

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

adjust to suit your range

--
HTH

Bob Phillips

"cdoyle" wrote in message
...
I want to find and highlight any cells that contain identical content.

All times are GMT +1. The time now is 09:20 AM.