To highlight duplicate rows with some colour [Closed]

Posts
1
Registration date
Thursday November 12, 2009
Status
Member
Last seen
November 13, 2009
- - Latest reply: sharpman
Posts
1022
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.
See more 

1 reply

Best answer
Posts
1022
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
214
4
Thank you
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

Say "Thank you" 4

A few words of thanks would be greatly appreciated. Add comment

CCM 6092 users have said thank you to us this month