Conditional formating

[wmehner]

I'm working on a simple conditional formating for a field, but I'm having a brain freeze.

I have a field called DUEDATE. I want it to be red when it's at or past the due date. I've got that part with the "self get (current date) format. But, I have a field called APPROVALDATE. I want the DUEDATE field to return to white when "any" date is put into the APPROVALDATE field. What is the conditional format for that? I'm new and stuck. Thanks.

[Fitch]

This should work:

APPROVALDATE > 0

Or:

not IsEmpty( APPROVALDATE )

[wmehner]

Thanks! I love this site!