Conditional Formatting for upcoming Dates in a Form

[Guest]

Just wondering how i can conditional format cells to highlight when a certain
date is coming up in the next month or two, and continue after it has passed.

ie when something is due for renewal we need to send out reminders

Thanks

Tim

 

[fredg]

Just wondering how i can conditional format cells to highlight when a certain
date is coming up in the next month or two, and continue after it has passed.

ie when something is due for renewal we need to send out reminders

Thanks

Tim

Set the control's conditional format property to:
Condition1 Expression is
Write:
DateDiff("m",[DateField],Date())<2 Or [DateField] > Date()
in the next control.
Set the colors as wanted.