Where to highlight duplicates in excel

Where are the duplicates highlighted in excel?

Open the document that needs to be operated.

Select the cell area where duplicate values ​​need to be highlighted.

Recommended: "Excel Tutorial"

Click the "Conditional Formatting" option in the "Start" menu bar.

Click on the "Highlight Cell Rules" option.

Click on the "Duplicate Values" option.

After setting the color and format to display duplicates, click "OK".

The above is the detailed content of Where to highlight duplicates in excel. For more information, please follow other related articles on the PHP Chinese website!