| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
font color depending upon value possible?
If you can't find a suitable format using Format/Cells/Number/Custom's
installed formats, try formatting the calculated cell with Format/Cells/Number/Custom [Black]General;[Red]General or [Black]General;[Red]-General etc. In article , "DrB" wrote: Would like to have calculated cell value from other cells show in black color if positive and in red if negative. Is this possible? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
font color less than another to show in red?
This way is best since one can copy format and paste on several other cells.
With conditioning format the cell letter doesn't increment to the pasted cell. Now is it possible with some cells that never go negative to compare the value with another and if less than have the font shown in red? "JE McGimpsey" wrote in message ... If you can't find a suitable format using Format/Cells/Number/Custom's installed formats, try formatting the calculated cell with Format/Cells/Number/Custom [Black]General;[Red]General or [Black]General;[Red]-General etc. In article , "DrB" wrote: Would like to have calculated cell value from other cells show in black color if positive and in red if negative. Is this possible? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
font color less than another to show in red?
No, you'll need to use CF for that.
In article , "DrB" wrote: Now is it possible with some cells that never go negative to compare the value with another and if less than have the font shown in red? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format for font color using font color | Excel Worksheet Functions | |||
| change font color depending on cell value | Excel Worksheet Functions | |||
| How do I get the font color to change automatically depending on | Excel Discussion (Misc queries) | |||
| How can I make cell A1 a "Y" or "N" depending upon cell A2's font color? Please help. | Excel Programming | |||
| Filling a listbox depending on font index | Excel Programming | |||
Hybrid Mode
