Two options:
Conditional formatting
or Format/ Cells/ Number/ Custom
--
David Biddulph

"Andy_Oscar_Charlie" wrote in
message ...
When performing a calculation I want to change the colour of the cell to
Red
if negative or Green if positive.