Results 1 to 2 of 2

Conditional Formating for Dates

  1. #1
    JoeJr is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Sep 2019
    Posts
    44

    Conditional Formating for Dates


    Hello All,

    I am working on formating color changes for date ranges. Here is the scinareo,

    A have a CompleteByDate Field, I need three conditions to change the color.

    Condition 1: If current date is 31 days from CompleteByDate; it turns Amber.
    Condition 2: If the CompleteByDate is ar or past current date it turns Red.
    Condition 3: If new CompleteByDate entered is greater than current date it turns green.

    I can get condition 1 and 3 to work but I can't get condition 2 to work.

    Please help.

    Thank

  2. #2
    JoeJr is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Sep 2019
    Posts
    44
    I figured it out. This action is complete.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Conditional Formating
    By Derrick T. Davidson in forum Reports
    Replies: 3
    Last Post: 07-18-2014, 09:25 AM
  2. Conditional Formating
    By Derrick T. Davidson in forum Forms
    Replies: 5
    Last Post: 04-13-2013, 07:18 AM
  3. Conditional Formating
    By redbull in forum Reports
    Replies: 2
    Last Post: 03-26-2012, 12:08 PM
  4. Conditional Formating help
    By Mounds in forum Forms
    Replies: 2
    Last Post: 02-10-2012, 11:07 AM
  5. Conditional formating!
    By karanvemuri in forum Access
    Replies: 3
    Last Post: 10-29-2011, 03:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums