If you've worked with Excel 2007 for a little while, you've probably noticed how much easier it is to delete duplicates.
What if you wanted to take a look at the duplicate values before you deleted them?
This is also very easy.
Simply highlight the range of cells you want to check for duplicates.
Click Conditional Formatting on the Home tab.
Click New Rule.
Click the line that reads format only unique or duplicate values.
Make sure duplicateis selected under format all.
Click the Format button to set your formats.
Click OK until you are back on your Excel screen.
That's it!
Excel Classes - Offered in Atlanta or Online
