Avatar of pdvsa
Flag for United States of America asked on

Highlight Duplicates


Is there code an expert can share to highlight ALL duplicates in column A?
It is a text column.  
I dont want to automatically delete 1 or both.
I realize there is functionality inside excel to delete duplicates.
I need to first see which one I should delete.

thank you.
Microsoft Excel

Avatar of undefined
Last Comment

8/22/2022 - Mon
Patrick Matthews

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

check out the conditional formatting bit in here: http://www.techrepublic.com/blog/msoffice/how-to-find-duplicates-in-excel/842

cheers, Amkick

what version of Excel are yo using? In 2010 (and 2007, I think) you can select the row > click "Conditional Formatting" on the "Home" tab > Select "Highlight Cells Rules" > Select "Duplicate Values" > Click "OK"

Check this File,its working and showing color when its duplicate :)
Your help has saved me hundreds of hours of internet surfing.

thanks.  How is a "rule" different from a simple conditional format on a range of cells such as "Highlight Cell Rules" then "duplicate values"?

ukerandi:  I like the button but after you delete the duplicate teh highlighting remains.  
Patrick Matthews

>>How is a "rule" different from a simple conditional format on a range of cells such as "Highlight Cell Rules" then "duplicate values"?

Two different ways of doing the same thing.  I rather suspect that Excel is kinda sorta applying that formula based rule in the background.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.

OK i see.   I was thinking that possibly if you go the formula route it is sorta like a data validation and more stringent type of formatting than the highlight cell route.  

yes but first you ask duplicate hightlight , but i can create automaticaly delete after you check manualy, for example without using Command Button,