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:

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