Select the data. Go to Home –> Conditional Formatting –> Highlight Cell Rules –> Duplicate Values. In the Duplicate Values dialog box, select Duplicate in the drop down on the left, and specify the format in which you want to highlight the duplicate values. This will highlight all the cells that have duplicates value in the selected data set.
这个只有office 365 enterprise 才有