Excel Highlight Duplicates

I would to create a macro where excel will look into column A and if there are duplicate values it will highlight the entire row where the duplicates exist. Any chance you can help me with this macro.

Thanks,

Chris
cansevinAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
aikimarkConnect With a Mentor Commented:
@cansevin

Take a look at the DuplicateMaster Add-in in this article.
http://www.experts-exchange.com/A_2123.html
0
 
DaveConnect With a Mentor Commented:
All points to aikimark above please

Use the settings as per this screenshot

Cheers

Dave
sm.png
0
 
aikimarkConnect With a Mentor Commented:
@Dave

Please take a look at this question where your Add-in experience might be beneficial:
http://www.experts-exchange.com/Q_26829378.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.