Home > Topics > excel > body text

How to highlight duplicate data in excel

藏色散人
Release: 2020-02-14 13:01:24
Original
40409 people have browsed it

How to highlight duplicate data in excel

How to mark duplicate data in red in excel

1. First, open the document to be edited with excel2016, and then select the column for which the input data is to be verified. .

How to highlight duplicate data in excel

2. Then click the "Conditional Formatting" button in the excel2016 ribbon

How to highlight duplicate data in excel

3. In the pop-up menu Select the "Blank Display Cell Rules" menu item, and select the "Duplicate Values" menu item in the pop-up secondary menu

How to highlight duplicate data in excel

4. In the pop-up "Duplicate Values" In the settings window, click the drop-down button to the left of "Value", select the "Repeat" menu item, and select the "Custom Format" menu item in the "Set as" drop-down menu

How to highlight duplicate data in excel

5. In the pop-up "Format Cells" window, click the "Fill" tab

How to highlight duplicate data in excel

6. Then select the background color you want to set below. color, and finally click the "OK" button to save and exit.

How to highlight duplicate data in excel

#7. In this way, when we count the inventory in the future, if we fill in a duplicate product, it will automatically be displayed in red to remind us that we have the product. To avoid duplicate statistics.

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

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

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!