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.

Who is Participating?
If you want to see how to apply CF then watch the video here..
Use the CF dialog on the Due Date field and set the conditions to,..

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.
callawarAuthor Commented:
Thanks for the comment.  Do you have an example where it is implemented to help me undertand the mechanics?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.