To highlight duplicate rows with some colour

Closed
Rashmi D S Posts 1 Registration date Thursday November 12, 2009 Status Member Last seen November 13, 2009 - Nov 13, 2009 at 05:33 AM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Nov 14, 2009 at 05:03 PM
Hello,
I am rashmi. i need your help regarding, to identify duplicate rows in excel sheet and highlight the same with some colour using macro programming. There are more than 1000 records in excel sheet could anyone please help me in this aspect.

1 reply

sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 183
Nov 14, 2009 at 05:03 PM
in excel 2007 you can do it this way.
highlight the cells/rows that you wish to work on.
select conditional formatting from the ribbon toolbar
highlight rules/duplicate values
set the colour you wish.
ok and apply.
this will highlight all that have duplicate values but the flaw is that this will give the same colour to all duplicate rows. but this will at least point out the duplicate rows for you.

hope this points you in the right direction
4