pdvsa
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 :)
BookColor.xlsm
BookColor.xlsm
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"?
ASKER
ukerandi: I like the button but after you delete the duplicate teh highlighting remains.
>>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.
Two different ways of doing the same thing. I rather suspect that Excel is kinda sorta applying that formula based rule in the background.
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.
yes but first you ask duplicate hightlight , but i can create automaticaly delete after you check manualy, for example without using Command Button,
cheers, Amkick