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

1. Open a work sample sheet as an example.

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

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.

4. Select the icon set in the format style.

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

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.

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

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!