Highlight duplicate values in Microsoft Excel 2010 using Mysql for Excel

Mysql for excel is an excel add-in used to easily import and export between MS Excel and Mysql database.

Example Sheet

Steps to Highlight Duplicate records

• Select the column


• Click on Home -->Conditional Formatting -->Highlight Cells Rules --> Duplicate Values, as given below

• Select the colors as below. Click "OK" to highlight all duplicate value

• Now you can see all the duplicate records highlighted as below.