Find Duplicate & No duplicate Information in an Excel Database

Find Duplicate & No duplicate Information in an Excel Database

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.