Access 2010 Conditional Formatting Based on Due Date

Posted on 2011-05-10
Last Modified: 2012-05-11
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.

Question by:callawar
    LVL 77

    Expert Comment

    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.

    Author Comment

    Thanks for the comment.  Do you have an example where it is implemented to help me undertand the mechanics?
    LVL 77

    Accepted Solution

    If you want to see how to apply CF then watch the video here..

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Suggested Solutions

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now