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

  • Thread starter Thread starter Newbie
  • Start date Start date
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.
 
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
 
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
 
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
 
Conditional Formatting under the Format menu is the way to
go. It's pretty self explanatory from there.
 
Back
Top