Hi Ann,

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

Regards,
Ivan