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?

Use options in Menu
format/conditional fomrting

"Joe" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
>
>
>
>

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


"Rajan Lengde" <[email protected]> wrote in message
news:%[email protected]...
> Use options in Menu
> format/conditional fomrting
>
> "Joe" <[email protected]> wrote in message
> news:[email protected]...
>> 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?
>>
>>
>>
>>
>>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
>
>
>
>

I can find the command or menu item you mentioned.

Where is it?
"L. Howard Kittle" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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?
>>
>>
>>
>>
>>
>
>