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

WBOY
Release: 2024-04-17 19:07:21
forward
1132 people have browsed it

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.

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

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.

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

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.

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

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

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

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!

source:zol.com.cn
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
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!