Formatting the text to automatic change clour

[Rameez Sarang]

Hi,

I need a help in the attached excel sheet and would like the font colour to change depending on the value inside them. They can remain grey if the number = 0.0, but I’d like them to be green if it’s a positive + change, or red if it’s a negative – change.

I have highlighted the cell in yellow as to where I want the change to happen.

Any help is much appreciated.

Thanks.

 

[pecoflyer]

and would like the font colour to change

The font color of what ?

 

[Rameez Sarang]

The font color of what ?

I have highlighted the cell in yellow as to where I want the change to happen. Check the screenshot attached