Highlight Duplicates

pdvsa
pdvsa used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010
Commented:
Assuming you have headings in Row 1...

1) Select A2:A???

2) Add a formula-based Conditional FOrmatting rule using the formula:

=COUNTIF(A:A,A2)>1

and select your formatting (such as, say, red or yellow fill)

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

cheers, Amkick

Commented:
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"
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Commented:
Check this File,its working and showing color when its duplicate :)
BookColor.xlsm
pdvsaProject finance

Author

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

Author

Commented:
ukerandi:  I like the button but after you delete the duplicate teh highlighting remains.  
Top Expert 2010

Commented:
>>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.
pdvsaProject finance

Author

Commented:
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.  

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial