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.

callawarAsked:
Who is Participating?
 
peter57rCommented:
If you want to see how to apply CF then watch the video here..
http://www.wonderhowto.com/how-to-apply-conditional-formatting-within-ms-access-2010-300283/
0
 
peter57rCommented:
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.
0
 
callawarAuthor Commented:
Thanks for the comment.  Do you have an example where it is implemented to help me undertand the mechanics?
0
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.