Hello Everyone,
I am having a hard time with what I see as a simple task. I have a sheet compromised of dates that people completed training. What I would like to see is a cell containing a date be highlighted red if its overdue by a year, highlighted yellow if it is within 30 days of its 1 year expiration, and highlighted green if its current within a year. The expiration's would be based of =TODAY(). Using Conditional Formatting I can get it to highlight red and yellow using =EDATE(TODAY(),-12) for Red, and =EDATE(TODAY(), 30) for yellow. But I haven't found a formula to get green to work. Any help would greatly appreciated!
-BroliniumFalcon
Bookmarks