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
PeterBartholomew1
Oct 31, 2020Silver Contributor
(Tried to edit this in to the previous post but wasn't allowed)
langben
Jun 26, 2021Copper Contributor
How do you color cell. Red if negative. Blue if positive
- SergeiBaklanJun 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