Changing Celll colour as a result of a calculation
 

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

Changing Celll colour as a result of a calculation
 

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.

Changing Celll colour as a result of a calculation
 

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.

Changing Celll colour as a result of a calculation
 

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


"Marcelo" wrote:


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.