Prev: Excel 2007: Saving a file with a Macro
Next: Pivot table formulas
From: Cheryl on 28 Apr 2010 10:33
I have the following formula for column D and E
=D2<Today() red
=(D2-Today())<30 green
I need to add a formula that if a date is in column c then column D and E
are black.

From: T. Valko on 28 Apr 2010 22:16
What are you formatting? The font color or the cell fill color?

--
Biff
Microsoft Excel MVP


"Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message
news:6C0EA3C7-7A01-42EB-9AF0-0B8E7DC99915(a)microsoft.com...
>I have the following formula for column D and E
> =D2<Today() red
> =(D2-Today())<30 green
> I need to add a formula that if a date is in column c then column D and E
> are black.
>


From: Cheryl on 29 Apr 2010 00:11
The font color.


"T. Valko" wrote:

> What are you formatting? The font color or the cell fill color?
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message
> news:6C0EA3C7-7A01-42EB-9AF0-0B8E7DC99915(a)microsoft.com...
> >I have the following formula for column D and E
> > =D2<Today() red
> > =(D2-Today())<30 green
> > I need to add a formula that if a date is in column c then column D and E
> > are black.
> >
>
>
> .
>
From: T. Valko on 29 Apr 2010 19:25
Ok, if you're formatting the font color then the default font color should
be black. So, you'd just need to modify your current formulas.

=AND(COUNT(C2)=0,D2<Today())

=AND(COUNT(C2)=0,D2-Today()<30)

The logic is: If C2 contains a date (which Excel evaluates as a number) then
the formula will evaluate as FALSE and the red or green font color *will
not* be applied leaving the default black font.

--
Biff
Microsoft Excel MVP


"Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message
news:D24E82C2-AAD6-4DE8-8424-146092126888(a)microsoft.com...
> The font color.
>
>
> "T. Valko" wrote:
>
>> What are you formatting? The font color or the cell fill color?
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message
>> news:6C0EA3C7-7A01-42EB-9AF0-0B8E7DC99915(a)microsoft.com...
>> >I have the following formula for column D and E
>> > =D2<Today() red
>> > =(D2-Today())<30 green
>> > I need to add a formula that if a date is in column c then column D and
>> > E
>> > are black.
>> >
>>
>>
>> .
>>


 | 
Pages: 1
Prev: Excel 2007: Saving a file with a Macro
Next: Pivot table formulas