Whether you acquire data from an exterior resource or have someone executing data entrance, mistakes can happen. If you’re concerned that you may have duplicate data in Microsoft Excel, you can find out promptly with conditional formatting.

You may have information for clients, locations, vendors, or something comparable where duplicate information can be inconvenient. But perhaps you have information like product, order, or repayment identifiers where replicates can be destructive. Here’s just how to discover that duplicate data fast in your Excel sheet.

Highlight Duplicate Data in Excel

Setting up conditional format regulations can occasionally get made complex. Thankfully, situating matches in your Excel sheet utilizing the attribute isn’t among those circumstances. You can in fact complete this task in simply a couple of clicks.

Start by picking the cells you wish to assess for matches. If your whole spreadsheet remains in concern, you can pick it instead by clicking the triangular in the upper left edge of the sheet.

Go to the Home tab and the Styles section of the bow. Click “Conditional Formatting,” transfer to “Highlight Cell Rules,” and also choose “Duplicate Values” in the pop-out menu.

When the Duplicate Values window displays, you need to instantly see your duplicates highlighted with the default formatting applied. Nonetheless, you can transform this if you desire.

Confirm that “Duplicate” shows in the very first drop-down box. After that, click the 2nd drop-down box to choose a various format. Click “OKAY” to apply the style to your replicate data.

If you like a format that isn’t detailed, click “Custom Format” in the drop-down box to choose a font, boundary, or load style in the succeeding pop-up window. Click “OK.”

You’ll see the Custom Format applied to the cell immediately. If you like it, click “OK” to use it.

Once you have your replicate data highlighted using conditional formatting, you can make the modifications or adjustments you require to. As well as when you do, the formatting will vanish as long as it’s not copied in other places in your cell selection.

Wondering what other methods conditional formatting can assist you discover data access blunders? Look into just how to highlight blank cells or errors with it in Excel.