How to mark red duplicate values in excel:
1. First open the excel software on your computer, and then open the table that needs to be processed in excel.
2. Next, select the entire table.
3. Then select "Home" - "Conditional Formatting" - "Highlight Cell Rules" in the upper toolbar.
#4. Next, select "Duplicate Value", select the fill color as red, and click OK.
#5. Then you can see that all duplicate names are marked in red.
Recommended learning: Excel Basic Tutorial
The above is the detailed content of How to highlight duplicate values in excel. For more information, please follow other related articles on the PHP Chinese website!
