Where to highlight duplicates in excel
- 藏色散人Original
- 2020-05-27 09:58:1128968browse
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!
Statement：
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
Previous article：How do I make a red circle in a table?Next article：How do I make a red circle in a table?