2. Choose Conditional Formatting on Excel’s Home menu. 3. Choose Highlight Cells Rules. 4. Choose Duplicate Values. 5. The Conditional Formatting feature offers a live preview, meaning any duplicate ...

If you want duplicate values to stand out in an Excel spreadsheet, you can choose between two conditional formatting rules.

We've doctored the data slightly to create some duplicated IDs. We've selected column A and then from the Home ribbon, Styles group, clicked on Conditional Formatting. We've chosen the Highlight Cells ...

You can easily discover the duplicate values in a Microsoft Excel spreadsheet using its conditional formatting duplicate highlighting feature.

You might be tempted to use one of Excel’s built-in conditional format rules (not available in 2003), but it won’t work as expected. It’ll hide each instance of a duplicate value.

Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. Learn the basics of this amazing feature.