callawar
asked on
Access 2010 Conditional Formatting Based on Due Date
How do I set the conditional formatting for the date text in Access 2010 with the following 3 conditions:
If date is less than 3-days from the Due Date the text turns yellow.
If the date is the Due Date (or later) the text turns red.
Any days prior to the 3-days Due Date, the text is normal.
If date is less than 3-days from the Due Date the text turns yellow.
If the date is the Due Date (or later) the text turns red.
Any days prior to the 3-days Due Date, the text is normal.
ASKER
Thanks for the comment. Do you have an example where it is implemented to help me undertand the mechanics?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Field Value is / Greater than or equal to/ Date()
and set the format you want.
Then add a new rule :
Field Value is / Greater than or equal to/ Date()-3
and set the format you want.