How to automatically change color and display duplicate data in excel table. Share the setting method and steps

How to automatically change the color of repeated data in Excel tables? Excel is our most commonly used tabular data processing tool. In Excel, if you want to automatically mark and color repeated data in a table, you can use the conditional formatting function to achieve this. This tutorial will introduce the repeated content of Excel to you. How to set the color change. Setup tutorial 1. Click to open the Excel table and you can see that there are duplicate data.

2. After selecting the data, click Conditional Formatting in the Home tab and click Highlight Cell Rules - Duplicate Values ​​in the sub-option.

3. Select the duplicate value in the window that opens, and you can see that the duplicate data in the table is marked.

4. If we want to mark it in another format, we can click the drop-down arrow as shown in the picture or select a custom format, then set the desired format in the window that opens and confirm.

5. You can set it to the specified format you want.

The above is the detailed content of How to automatically change color and display duplicate data in excel table. Share the setting method and steps. For more information, please follow other related articles on the PHP Chinese website!