Prev: worksheet change question
Next: median standard deviation
From: Rob on 20 Apr 2010 14:03
I want a cell to be coloured red if the result of a simple calculation is
negative, and coloured green if the result is positive. Can anyone tell me
how to do this?
--
Thanks for your help

Rob
From: JLatham on 20 Apr 2010 14:08
Use Conditional Formatting.
Cell Value "less than" 0 and set format to red (font or fill), then add
a second condition
Cell Value "greater than" 0 and set the format to green.


"Rob" wrote:

> I want a cell to be coloured red if the result of a simple calculation is
> negative, and coloured green if the result is positive. Can anyone tell me
> how to do this?
> --
> Thanks for your help
>
> Rob
From: Eduardo on 20 Apr 2010 14:16
Hi,
use conditional formating, where the formula is enter

=$C$1>0 choose color green

do the same again enter formula

=$C$1<0 choose color red

"Rob" wrote:

> I want a cell to be coloured red if the result of a simple calculation is
> negative, and coloured green if the result is positive. Can anyone tell me
> how to do this?
> --
> Thanks for your help
>
> Rob
 | 
Pages: 1
Prev: worksheet change question
Next: median standard deviation