Link to home
Start Free TrialLog in
Avatar of callawar
callawarFlag for Türkiye

asked on

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.

Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

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.
Avatar of callawar

ASKER

Thanks for the comment.  Do you have an example where it is implemented to help me undertand the mechanics?
ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial