M
mjones
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
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