| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I reatin the color of text when I use a formula | Excel Discussion (Misc queries) | |||
| Cond. format text color based on another's text color | Excel Discussion (Misc queries) | |||
| Change color of font base on time range | Excel Discussion (Misc queries) | |||
| Sumif and base it on font color of cell | Excel Worksheet Functions | |||
| change tab color base on cell value | Excel Programming | |||
![Joe[_43_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
