Conditional Format Formula Needed

[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

 

[Dave Peterson]

maybe...

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

 

[Trevor Shuttleworth]

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]

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

Thanks all!