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.