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
langben
Jun 26, 2021Copper Contributor
How do you color cell. Red if negative. Blue if positive
SergeiBaklan
Jun 26, 2021Diamond Contributor
That's in Riny_van_Eekelen post in this thread above
- langbenJul 03, 2021Copper ContributorHi Sergei,
Thank you very much for the response to my question.
Best Wishes,
Ben