color text base of value of the formula
 

Hi,

Is there a way to make the results of a formula in a cell a certain color
(red, green... etc) base on the results of the forumla (below zero its red,
above, its green). And if its above 50 its dark green? below
-50 its pink?

color text base of value of the formula
 

Use options in Menu
format/conditional fomrting

"Joe" wrote in message
...
Hi,

Is there a way to make the results of a formula in a cell a certain color
(red, green... etc) base on the results of the forumla (below zero its
red,
above, its green). And if its above 50 its dark green? below
-50 its pink?

color text base of value of the formula
 

Can you what do you mean?
I can't find what you are saying


"Rajan Lengde" wrote in message
...
Use options in Menu
format/conditional fomrting

"Joe" wrote in message
...
Hi,

Is there a way to make the results of a formula in a cell a certain color
(red, green... etc) base on the results of the forumla (below zero its
red,
above, its green). And if its above 50 its dark green? below
-50 its pink?

color text base of value of the formula
 

Hi Joe,

Conditional formatting allows three conditions and you want four.

Try this,

Format the cell to light green which will be the 0 + color.
Condition 1 Cell value Greater than 50
Condition 2 Cell value Less than -50
Condition 3 Cell value Less than 0

I believe this gets you there.

HTH
Regards,
Howard

"Joe" wrote in message
...
Hi,

Is there a way to make the results of a formula in a cell a certain color
(red, green... etc) base on the results of the forumla (below zero its
red,
above, its green). And if its above 50 its dark green? below
-50 its pink?

color text base of value of the formula
 

I can find the command or menu item you mentioned.

Where is it?
"L. Howard Kittle" wrote in message
...
Hi Joe,

Conditional formatting allows three conditions and you want four.

Try this,

Format the cell to light green which will be the 0 + color.
Condition 1 Cell value Greater than 50
Condition 2 Cell value Less than -50
Condition 3 Cell value Less than 0

I believe this gets you there.

HTH
Regards,
Howard

"Joe" wrote in message
...
Hi,

Is there a way to make the results of a formula in a cell a certain color
(red, green... etc) base on the results of the forumla (below zero its
red,
above, its green). And if its above 50 its dark green? below
-50 its pink?