Hi, I have a long sheet and need to find all the duplicates and add a border those rows.
I was able to highlight all the rows with duplicates using a Kutools feature.
highlighted rows.png
How can I have excel find the duplicates and put boxes around them like this?
Highlight with borders.PNG
Thank you
Kim
Bookmarks