Conditional formatting makes my numbers pop out just right, and I've never felt more in control of my spreadsheets. Say ...

Whether you're highlighting key performance indicators, identifying duplicates, or using color scales to represent data ...

Excel will only remove exact duplicates. In this example, the second Square is misspelled as Squarre, so after duplicates are removed, both spellings of Square remain. 6. You can also highlight a ...