Forum Discussion

Copper Contributor

Oct 31, 2020

Solved

Conditional number color format

#Office365 #Office2016 (If conditional formats) Hi All. Is there a way that I can make a returned sum of numbers a specific color? I would like negative numbers to be red, positive numbers green ...

excel

Formulas and Functions

Wyn Hopkins
Oct 31, 2020
Hi PeterVelschow

The simplest and most flexible approach is to use Conditional Formatting

Just apply 3 rules

Riny_van_Eekelen

Platinum Contributor

Oct 31, 2020

PeterVelschow Look into applying custom number formats to achieve this. An example is given in the picture below.

More about customising number formats here:

https://support.microsoft.com/en-us/office/review-guidelines-for-customizing-a-number-format-c0a1d1fa-d3f4-4018-96b7-9c9354dd99f5