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.
No comments:
Post a Comment