Help!! To modify existing formula

H

housinglad

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
 
B

Brian

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.
 
D

David Biddulph

Conditional formatting has been available from well before Excel 2007.
Under the Format menu.
 
Top