Conditionally Formatting a Date in Access 2016

[Delfina]

I have no idea if this is possible. But is there a way to conditionally format a date to turn yellow if it is 75 days previous to today's date or turn red if it is 90 days previous to today's date. I have played around with right clicking on the field and trying to do it. It probably takes code that I know nothing about. I have created a sample database with just a few things in it to try it out.

[pbaldy]

No code required, check out Conditional Formatting on the ribbon (with a form or report in design view and the desired textbox selected).

[pbaldy]

By the way, you'd use Field Value Is, Less Than, and Date() - 90. Conditions are applied in order, so you'd want the older test first.

[Delfina]

Thank you so much. It worked. That was so easy. I was trying it in different ways with these symbols. < > You guys are geniuses.

[pbaldy]

Excellent, happy to help!