You can do this in any order (e. g. , click the lower right-hand box first, then highlight from there).
If you instead wish to display all unique values, you can select “Unique” instead.
Once you delete a one-time duplicate, its partner value will lose its highlight.
If you have multiple sections of your spreadsheet formatted, you can select a specific area and click “Clear Rules from Selected Cells” to remove their highlighting.
You can do this in any order (e. g. , click the lower right-hand box first, then highlight from there).
If the program tells you that there aren’t any duplicates–especially if you know there are–try placing a check next to individual columns in the “Remove Duplicates” window. Scanning each column one at a time will resolve any errors here.
