MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Highlight Duplicates


Posted by sdennison on June 20, 2001 6:00 AM

Does anyone have a macro that will highlight duplicate rows. I have a spreadsheet that has 9 columns and if column B contains a duplicate vendor number I want to highlight it.


Posted by zen on June 20, 2001 6:34 AM

you can highlight it with conditional formating

some like Formula Is =COUNTIF($L$2:$L$105,L87)>1 this can be applied to the whole sheet but just use the range as the one that may have duplicates, any help?

good luck

zen