Excel - How to highlight duplicate rows?

Latest update on November 7, 2012 at 10:17 AM by deri58 .

Issue
Solution
Note

Issue

I need to identify duplicate rows in an Excel sheet and highlight them using a defined color. How to proceed?

Solution

Highlight the cells/rows.
Select conditional formatting from the ribbon toolbar
Highlight rules/duplicate values
Set the color you wish.
Ok and apply.

This will highlight all that have duplicate values but the problem is that it will give the same color to all duplicate rows. But this will at least point out the duplicate rows for you.

Note

Thanks to sharpman for this tip on the forum.

Duplicate rows in excel
Color duplicate rows in excel - Best answers
Identify duplicate rows in excel - Best answers
Excel - Macro to highlight Rows with Duplicate values in a cell ✓ - Forum - Excel
Excel duplicate row multiple times ✓ - Forum - Office Software
Copy and insert rows and number of times ✓ - Forum - Excel
Copy rows n times in Excel ✓ - Forum - Excel
Excel formula to duplicate rows based on cell value ✓ - Forum - Excel

This document, titled « Excel - How to highlight duplicate rows? », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

Excel VBA - - Msg Box when cell meets criteria

Excel - Re-arrange data from columns into rows

Issue

Solution

Note

Subscribe To Our Newsletter!