Home > Software Tutorial > Office Software > The operation content of setting positive numbers to check and negative numbers to cross in the Excel table

The operation content of setting positive numbers to check and negative numbers to cross in the Excel table

王林
Release: 2024-03-29 13:42:13
forward
995 people have browsed it

1. Open a work sample sheet as an example.

The operation content of setting positive numbers to check and negative numbers to cross in the Excel table

2. You can see that the number entered in the cell is represented by red parentheses for negative numbers, while positive numbers are black.

The operation content of setting positive numbers to check and negative numbers to cross in the Excel table

3. This rule is the rule for number display. We can set a new rule to make the number display more eye-catching. As the title says, positive numbers are ticked and negative numbers are ticked. cross. Select the range cells and select New Rule in Conditional Formatting.

The operation content of setting positive numbers to check and negative numbers to cross in the Excel table

4. Select the icon set in the format style.

The operation content of setting positive numbers to check and negative numbers to cross in the Excel table

5. Set the style of the icon. The style is divided into three conditional formatting icons, namely greater than equal to and less than.

The operation content of setting positive numbers to check and negative numbers to cross in the Excel table

6. Set the specific value of the conditional format. Here we set it to be greater than 0, less than 0 and equal to 0. The type is changed to numerical value.

The operation content of setting positive numbers to check and negative numbers to cross in the Excel table

7. After clicking OK, return to the excel form. You can see that a check icon is added in front of the original value.

The operation content of setting positive numbers to check and negative numbers to cross in the Excel table

Dear friends who have just come into contact with Excel software, come and study this article today. I believe you will be comfortable in using it in the future.

The above is the detailed content of The operation content of setting positive numbers to check and negative numbers to cross in the Excel table. For more information, please follow other related articles on the PHP Chinese website!

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