Conditional Formatting - Range of Dates

[Ann]

I'm setting up a "tasks" spreadsheet and using condition formatting to
alert missed dates. This is a simple formula, but I'm still struggling.
If I use the formula below for past due tasks, all cells appear red
except those due today and in the future. How do I write the formula
for Condition 3 so I'm not highlighting empty cells?

Condition 1: =$D4=TODAY() [green cell]


Condition 2: =$B4="Closed" [grey cell]


Condition 3: =$D4<TODAY() [red cell]

[Ardus Petus]

Condition 3: =AND($D4<>"",$D4<TODAY())

HTH
--
AP

"Ann" <Ann@discussions.microsoft.com> a écrit dans le message de news:
D8413320-9C42-4451-ABDC-469A09A4E545@microsoft.com...
> I'm setting up a "tasks" spreadsheet and using condition formatting to
> alert missed dates. This is a simple formula, but I'm still struggling.
> If I use the formula below for past due tasks, all cells appear red
> except those due today and in the future. How do I write the formula
> for Condition 3 so I'm not highlighting empty cells?
>
> Condition 1: =$D4=TODAY() [green cell]
>
>
> Condition 2: =$B4="Closed" [grey cell]
>
>
> Condition 3: =$D4<TODAY() [red cell]
>
>
>

[papou]

Hello
I would suggest you amend:
=AND($D4<>"",$D4=TODAY())
=AND($D4<>"",$D4<TODAY())


HTH
Cordially
Pascal

"Ann" <Ann@discussions.microsoft.com> a écrit dans le message de news:
D8413320-9C42-4451-ABDC-469A09A4E545@microsoft.com...
> I'm setting up a "tasks" spreadsheet and using condition formatting to
> alert missed dates. This is a simple formula, but I'm still struggling.
> If I use the formula below for past due tasks, all cells appear red
> except those due today and in the future. How do I write the formula
> for Condition 3 so I'm not highlighting empty cells?
>
> Condition 1: =$D4=TODAY() [green cell]
>
>
> Condition 2: =$B4="Closed" [grey cell]
>
>
> Condition 3: =$D4<TODAY() [red cell]
>
>
>

[Ivan Raiminius]

Hi Ann,

Condition 3: =($D4<TODAY())*($d4<>0)

Regards,
Ivan