Find Duplicates in Excel 2010 & 2013
Please Change Video Quality.
Excel's conditional formatting feature is an easy way to add special formatting features to specific areas of your spreadsheets. Depending on the value in a cell, you can change things like the font color of specific data or alter the background color of a cell (or cells).
The "conditional" part of the name means that you can control when and where the formatting changes are applied. If the data meets a certain condition, then the formatting change occurs.
One common use for this feature is to find duplicate data such as duplicate names, dates, or formulas in large tables of data.