if positive... print in green, if negative print red

[Newbie]

I would like to program a cell to print green if the
number is positive and red if negative. Is this possible
in excel and if so do you have a formula that will do
this? Thank you.

 

[CLR]

Format > Conditional Formatting.............Cell value is > "Greater than"
0, set format for Red font, and then Add > second Conditional format > Cell
value is > "Less than" 0, set format for Green font...........

Vaya con Dios,
Chuck, CABGx3

 

[GAIL HORVATH]

You can use the conditional format function for this (click on format on the
toolbar and then conditional format)

--
Gail M Horvath
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(856) 589-4152

 

[Ron Rosenfeld]

I would like to program a cell to print green if the
number is positive and red if negative. Is this possible
in excel and if so do you have a formula that will do
this? Thank you.

There is no need to use Conditional Formatting for something like this. Merely
format the cell:

Cells/Format/Number Custom Type: [Green]0.0;[Red]-0.0;0.0

and that prints in black if the number is exactly zero. You can change the
format of the number itself to anything Excel will accept.


--ron

 

[mtkatrev]

Conditional Formatting under the Format menu is the way to
go. It's pretty self explanatory from there.