• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 855
  • Last Modified:

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.

0
callawar
Asked:
callawar
  • 2
1 Solution
 
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
 
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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now