Avatar of pdvsa
pdvsa
Flag for United States of America asked on

Highlight Duplicates

Hello,

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
ukerandi

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
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
or
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
Amkick

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

cheers, Amkick
Eonasdan

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"
ukerandi

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

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

ASKER
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.
pdvsa

ASKER
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.  
ukerandi

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