Forum Discussion

PeterVelschow's avatar
PeterVelschow
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's avatar
    Wyn Hopkins
    Oct 31, 2020

    Hi PeterVelschow 

     

    The simplest and most flexible approach is to use Conditional Formatting

     

    Just apply 3 rules

     

Wyn Hopkins's avatar
Wyn Hopkins
MVP
Oct 31, 2020

Hi PeterVelschow 

 

The simplest and most flexible approach is to use Conditional Formatting

 

Just apply 3 rules

 

  • PeterVelschow's avatar
    PeterVelschow
    Copper Contributor
    Oct 31, 2020

    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

Resources