How to filter and color-code duplicate items in excel

How to filter and colorize duplicate items in excel: first open the table and select the cell; then on the start interface, click "Conditional Formatting"; then in the drop-down option, click "Highlight Cell Rules"; finally click "Repeat value" and set the color, then click "OK".

The operating environment of this article: windows7 system, WPS Office2019 version, DELL G3 computer

Open the table on the computer and select the cell.

On the start interface, click "Conditional Formatting".

In the drop-down option, click "Highlight Cell Rules".

The drop-down option appears, click "Duplicate Value".

A window will appear, set the color, and click "OK".

#excel duplicates have been filtered and colored.

For more related articles, please visit the FAQ column!

The above is the detailed content of How to filter and color-code duplicate items in excel. For more information, please follow other related articles on the PHP Chinese website!