Microsoft Office Tutorials and References
In Depth Information
Tip 60: Finding Duplicates by Using Conditional Formatting
Finding Duplicates by Using Conditional
Formatting
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
dialog box.
3.
In the Conditional Formatting dialog box, select the option labeled Use a Formula to
Determine Which Cells to Format.
