??? Conditional Formatting ???

G

Guest

I am going to have to ask again for help on this one. I have a series of
date fields in control boxes that need conditional formatting.

Date1 Date1due Date2 Date2due Date3

Date1 is filled with date entered in field when request is mailed.
Date1due is filled with conditional format (field Value Is less than or
equal to Date() - this date is bolded and red.
Date2 (this is where I am stuck!!!) When I enter a date in Date2, I want
the conditional format set for Date1due to Unbold and set the font back to
black in Date1due.
I want the same process for Date3.

Please can someone help me. I really need to make this work for tracking.
Thank you.
 
W

Wayne Morgan

For Date1Due, set the drop down for the condition to Expression instead of
<=. Then for the expression:

[Date1]<=Date() And Not IsDate([Date2])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top