Alternatively, select the cells ... so I'm good to click "OK." Excel then tells you how many duplicates it has removed. In my example, 50 appeared in the list three times, and 19 appeared twice ...

When I select column A, click "Format Painter," and select column C, Excel duplicates the conditional formatting rule for ...

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 ...