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

N

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.
 
C

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
 
R

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.
Click to expand...

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
 
M

mtkatrev

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