Thread: Help!! To modify existing formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
housinglad housinglad is offline
external usenet poster
  
Posts: 19
Default 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
Reply With QuoteReply With Quote