??? Conditional Formatting ???

T

TotallyConfused

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])
 
Top