Forum Discussion
Conditional Formatting using months instead of days
Hey Everybody, I work for an airline and for our due date tracking we use calendar months for due dates. With these calendar month due dates, you have a three month "grace" window to complete the e...
There was another query very similar to yours not long ago. That other one had to do with emergency medical training (CPR, etc) that could expire. The inquirer wanted dates to turn yellow at a certain point, red at another, just as you're asking.
I created the attached spreadsheet to illustrate how the Conditional Formatting rules could be written, referring both to the TODAY() function AND to a separate table to control those trigger points at which the subject cells would turn yellow or red or whatever you wanted.
It sounds like you're quite adept with Excel, so I'm going to let you adapt this example to your own situation. Feel free to come back with questions, though, if you have them.