how do i find cells that repeat the same content?

  • Thread starter Thread starter Guest
  • Start date Start date
Use conditional formatting with a formula of

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

adjust to suit your range
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Based on Cell Content 3
How do I change contents of a cell based on drop down list selecte 2
Excel Import Comments 3
VBA set thick borders around non empty cells in range 0
Find & Replace: find part cell, replace whole cell 2
Mult formula cell displays "0", which formula created result? 3
Macro to transfer contents of 'Selected' cell to alternate cell. 7
Displaying items from a column list in another sheet? 18

Back
Top