Using conditional formatting it seems to work like this. Select your range
and then on the conditional formatting menu change to Formula and insert the
below formula, pick how you want it highlighted.

=COUNTIF($A$2:$E$5000,A2:IS2)>1

I'm no expert, but I was able to figure it out. Perhaps one of the more
experienced people here can offer something better, but as far as I can tell
this will work.

I attached the workbook I edited.

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Attachment: Copy of Highlight+Duplicated+Rows+Example.xls
Description: MS-Excel spreadsheet

Reply via email to