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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formating Help 1
Search formula showing results plus 100 characters 2
Complex Question on Filtering on a merged column 1
Function Error? 3
Return blank not 0 4
Changing font style and color using VBA 3
Newbie Help - IF Yes No Function 0
I need to hide a formula 6

Top