Excel tip: Highlight rows containing duplicates

Kashflow logo

This excerpt from David Ringstrom’s High Impact Excel series on our US sister site shows how you can apply conditional formatting to rows that include duplicates.

A previous tip in 2013 explained how to identify duplicate cells in a worksheet, but David was challenged to find a way to not only identify duplicates in a single column, but also flag the adjacent cells in the same row.

This tip presents his solution in two parts. The first explains how to identify duplicate values in a single column, and the second part shows how to extend the technique. The tip is passed on Excel 2007 and later editions. To highlight rows with duplicates using these techniques in in Excel 2003 and Excel for Mac 2011, see David’s original a...

Please Login or Register to read the full article

The full article is available to registered AccountingWEB.co.uk members only. To read the rest of this article you’ll need to login or register. Registration is FREE and allows you to view all content, ask questions, comment and much more.

About David H Ringstrom


Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.

Related content