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