Forum Discussion
PeterVelschow
Oct 31, 2020Copper Contributor
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 ...
- Oct 31, 2020
The simplest and most flexible approach is to use Conditional Formatting
Just apply 3 rules
Wyn Hopkins
Oct 31, 2020MVP
The simplest and most flexible approach is to use Conditional Formatting
Just apply 3 rules
PeterVelschow
Oct 31, 2020Copper Contributor
Hi Wyn Hopkins
Thanks a lot for the fast and clarifying response. I had searched for precisely that way to color my numbers, but simply oversaw it. Now things work as a charm 🙂
Regards
Peter