1. Computing
Ted French

Find Duplicate Data Entries with Conditional Formatting

By June 19, 2013

Follow me on:

Find Duplicates in Excel 2007 Using Conditional Formatting
Finding Duplicates in Excel
© Ted French

The "conditional" part of conditional formatting means that you can control when and where specific formatting changes are applied.

If the data you have selected meets certain conditions, then the formatting change, such as changing the font color or altering the background color of a cell, occurs.

A great use for this feature is to find duplicate data such as duplicate names, dates, or formulas in large tables of data.

To find out how to use this wonderful feature in Excel read the tutorial on how to Find Duplicate Data with Conditional Formatting.

Related Tutorials
Comments
No comments yet. Leave a Comment
Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.