In Excel, some friends say that positive and negative numbers are not displayed in different colors yet. In fact, it is very simple. Here is the editor’s tutorial on how to display positive and negative numbers in different colors in Excel. Friends who don’t know how to operate it, hurry up. Let’s find out.

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

Method 1: Use custom format to distinguish positive and negative colors

​​Select the data in column D, press CTRL+1, open the custom format, and enter the code in the type: [green]0.00%;[red]-0.00%;-

The meaning of the code: Positive numbers greater than 0 are displayed as a green 2-digit percentage, and negative numbers less than 0 are displayed as a red 2-digit percentage.

Method 2: Use conditional formatting to distinguish positive and negative colors

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

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

Today, let’s learn how to display positive and negative numbers in different colors in Excel. I believe it will definitely help friends in need.