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.
 

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
How do I skip over null cells? 4
Complex Question on Filtering on a merged column 1
Need formula help 4
Changing font style and color using VBA 3
An easier way? 9
I need to hide a formula 6
counting multiple criteria using SUMPRODUCT and getting #VALUE err 1

Top