Changing Celll colour as a result of a calculation

[Andy_Oscar_Charlie]

When performing a calculation I want to change the colour of the cell to Red
if negative or Green if positive.

 

[Marcelo]

hi,

use conditional format to do this.

go to menu format --> conditional format

Condition 1
Cell value is Less than 0
Format as you want,

condition 2
cell value is greather than or equal to 0
Format as you want

hth




--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Andy_Oscar_Charlie" escreveu:

 

[John C]

Actually, it depends on how he wants to handle any 0 response. 0 isn't a
positive number.