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