Turn off the Advanced Filter before you process your data to remove duplicates. Excel's conditional formatting enables you to reveal duplicates by applying a special color to the text of values ...