Report

[cbuechner]

I have a column in a report (date). I want to have conditional formatting for anything that is

1. Expired (RED)
2. Within 90 days of expiring (Yellow)

I am familiar with Excel, however, cant get that to work on this report. I know how to add it, just not sure of the formula. Also, the date field is formatted as a date.

[Micron]

Always post what you tried whenever you can. Saves us from having to create from scratch and make up names for things when you could reveal those names with your attempt(s). Or you could just read an article like these:
https://support.microsoft.com/en-gb/...d-a260125c8129
https://www.dummies.com/software/mic...n-access-2019/

[ranman256]

in the report query, add a column for the #days.
then do your condtional format.

[cbuechner]

Thank you and I reviewed these articles. I was able to figure it out with this help. Thank you. I always try and research before asking, and I guess I wasn't searching for the right topic.