Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help!! To modify existing formula
Hi
A cell (H6) in my spreadhseet currently contains the following formula: =IF(ISBLANK(G6),"",NETWORKDAYS(E6,G6)) If the value returned is 1 then i want the font in the cell to turn red. Please help. Thanks Dan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help!! To modify existing formula
If you are using Excel 2007 you can use conditional formatting. It should
show up on the "Home" banner. If you're not in 2007, not sure that it can be done. "housinglad" wrote: Hi A cell (H6) in my spreadhseet currently contains the following formula: =IF(ISBLANK(G6),"",NETWORKDAYS(E6,G6)) If the value returned is 1 then i want the font in the cell to turn red. Please help. Thanks Dan |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help!! To modify existing formula
Conditional formatting has been available from well before Excel 2007.
Under the Format menu. -- David Biddulph Brian wrote: If you are using Excel 2007 you can use conditional formatting. It should show up on the "Home" banner. If you're not in 2007, not sure that it can be done. "housinglad" wrote: Hi A cell (H6) in my spreadhseet currently contains the following formula: =IF(ISBLANK(G6),"",NETWORKDAYS(E6,G6)) If the value returned is 1 then i want the font in the cell to turn red. Please help. Thanks Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modify the existing formula | New Users to Excel | |||
How do I delete or modify an existing drop down list? | Excel Discussion (Misc queries) | |||
Modify a Formula | Excel Worksheet Functions | |||
Modify an existing Cell formula using VBA | Excel Discussion (Misc queries) | |||
How do I modify an existing worksheet to remove columns & contents | Excel Discussion (Misc queries) |