| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color
How do you display a certain color in a cell for a formula for example in the
formula = IF C4-C50 than display "Order", but display cell in red but in same cell = IF C4-C5<0 than display "No Order", but display in Green I know it is confusing but how do I do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Color
Use conditional formatting on format menu for change color as you want.
use this formula in condition formatting for C4-C5 0 =C4C5 and use this formula in conditional formatting for C4-C5 < 0 in condition2 =C4<C5 "Justin" wrote: How do you display a certain color in a cell for a formula for example in the formula = IF C4-C50 than display "Order", but display cell in red but in same cell = IF C4-C5<0 than display "No Order", but display in Green I know it is confusing but how do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort or sub-total by Fill color or font color | Excel Discussion (Misc queries) | |||
| Color Formats | Excel Discussion (Misc queries) | |||
| Edit Color Palette Names | Excel Discussion (Misc queries) | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| Color a cell and a value is automatically assigned to that color. | Excel Worksheet Functions | |||
Linear Mode
