A simple tutorial on how to display positive and negative numbers in different colors in Excel

When processing Excel table data, how to distinguish between positive and negative numbers? PHP editor Xinyi brings you a tutorial on how to display positive and negative numbers in different colors in Excel, so that you can clearly identify positive and negative numbers at a glance. This tutorial will introduce in detail the steps to use the conditional formatting function to display positive and negative numbers in different colors, helping you to easily solve data visualization problems and improve work efficiency.

As shown in column D below, positive numbers are represented in green and negative numbers are represented in red.

Operation method one: Use custom format to distinguish positive and negative colors

Select the data in column D, press CTRL 1, open the custom format, and enter in the type Code: [Green] 0.00%; [Red] -0.00%; -

Code meaning: Positive numbers greater than 0 are displayed with a green 2-digit percentage, negative numbers less than 0 are displayed with a red 2-digit percentage The percentage is displayed.

Operation method two: Use conditional formatting to distinguish positive and negative color colors

Select the data area, conditional formatting - highlight cell rules - greater than, less than to set Set color.

Here, a negative number less than 0 is used to set the color. The final result is as shown in the figure:

The above is the detailed content of A simple tutorial on how to display positive and negative numbers in different colors in Excel. For more information, please follow other related articles on the PHP Chinese website!