How to set excel to display red when greater than 0?

Method: 1. Open the excel table and select the data that needs to be operated; 2. Click "Conditional Formatting" in the menu bar, and then click "Greater than (G)" in "Highlight Cell Rules"; 3. Select greater than "0", "Custom Format" will be filled with red, and click "OK".

Method:

1. Create a blank EXCEL;

2. Create a new column of data and insert sample data; -55, 123, 12, -9, 0;

3. Select 'Conditional Formatting' '-'Highlight cell rule'-'Greater than (G)';

4. Select greater than '0', and the custom format is filled with red;

5, you can find cells greater than 0 and fill them with red;

Recommended tutorial ：《excel tutorial》

The above is the detailed content of How to set excel to display red when greater than 0?. For more information, please follow other related articles on the PHP Chinese website!