Conditional Formatting for upcoming Dates in a Form

T

Tim M

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
 
F

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
Click to expand...

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.
 
Top