Microsoft Office Tutorials and References
In Depth Information
Tip 60: Finding Duplicates by Using Conditional Formatting
Finding Duplicates by Using Conditional
You might find it helpful to identify duplicate values within a range of cells. For example, take a look
at Figure 60-1. Are any of the values duplicated?
One approach to identifying duplicate values is to use conditional formatting. After applying a
conditional formatting rule, you can quickly spot duplicated cell values.
Figure 60-1: You can use conditional formatting to quickly identify duplicate values in a range.
Here’s how to set up the conditional formatting:
1. Select the cells in the range (in this example, A1:G22).
2. Choose Home➜Conditional Formatting➜New Rule to display the Conditional Formatting
3. In the Conditional Formatting dialog box, select the option labeled Use a Formula to
Determine Which Cells to Format.