Hi All,

I'm trying to say something like this =(C$9+30<$D$67)+H$9<>x, which is
probably not close.

I want to make a H9 red when its past due. It's past due when C9 is
more than 30 days from the current date in D67 and not paid. It's
paid when G9 has an x in it.

C9 - date invoiced, i.e. 1/18/2007 (date format 18-Jan)
D67 - current date, i.e. 3/14/2007 (date format 14-Mar)
G9 - balance due, which should turn red if late
H9 - paid there's an x in the cell (general format)

Can anyone help with this formula?

Thanks,

Michele

maybe...

=and((c$9+30<$d$67),(H$9<>"X"))
or
=and((c$9+30<today()),(H$9<>"X"))



mjones wrote:
>
> Hi All,
>
> I'm trying to say something like this =(C$9+30<$D$67)+H$9<>x, which is
> probably not close.
>
> I want to make a H9 red when its past due. It's past due when C9 is
> more than 30 days from the current date in D67 and not paid. It's
> paid when G9 has an x in it.
>
> C9 - date invoiced, i.e. 1/18/2007 (date format 18-Jan)
> D67 - current date, i.e. 3/14/2007 (date format 14-Mar)
> G9 - balance due, which should turn red if late
> H9 - paid there's an x in the cell (general format)
>
> Can anyone help with this formula?
>
> Thanks,
>
> Michele

--

Dave Peterson

Close:

=AND(C$9+30<$D$67,H$9<>"x")

Do you want H9 red or G9 ? You said H9 in the description and G9 in the
example. Either case, it's the same formula

Regards

Trevor


"mjones" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All,
>
> I'm trying to say something like this =(C$9+30<$D$67)+H$9<>x, which is
> probably not close.
>
> I want to make a H9 red when its past due. It's past due when C9 is
> more than 30 days from the current date in D67 and not paid. It's
> paid when G9 has an x in it.
>
> C9 - date invoiced, i.e. 1/18/2007 (date format 18-Jan)
> D67 - current date, i.e. 3/14/2007 (date format 14-Mar)
> G9 - balance due, which should turn red if late
> H9 - paid there's an x in the cell (general format)
>
> Can anyone help with this formula?
>
> Thanks,
>
> Michele
>

Worked great! Liked the one with today() so I don't have to update
the date field all the time.

Thanks all!

On Mar 14, 2:56 pm, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> maybe...
>
> =and((c$9+30<$d$67),(H$9<>"X"))
> or
> =and((c$9+30<today()),(H$9<>"X"))
>
>
> mjones wrote:
>
> > Hi All,
>
> > I'm trying to say something like this =(C$9+30<$D$67)+H$9<>x, which is
> > probably not close.
>
> > I want to make a H9 red when its past due. It's past due when C9 is
> > more than 30 days from the current date in D67 and not paid. It's
> > paid when G9 has an x in it.
>
> > C9 - date invoiced, i.e. 1/18/2007 (date format 18-Jan)
> > D67 - current date, i.e. 3/14/2007 (date format 14-Mar)
> > G9 - balance due, which should turn red if late
> > H9 - paid there's an x in the cell (general format)
>
> > Can anyone help with this formula?
>
> > Thanks,
>
> > Michele
>
> --
>
> Dave Peterson- Hide quoted text -
>
> - Show quoted text -