Prev: Printing dynamic labels
Next: How do I enter rows to repeat on sheet tab?
From: housinglad on 11 Feb 2010 15:51
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
From: Brian on 11 Feb 2010 15:56
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
From: "David Biddulph" groups [at] on 11 Feb 2010 16:18
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


 | 
Pages: 1
Prev: Printing dynamic labels
Next: How do I enter rows to repeat on sheet tab?