I am creating a training spreadsheet that records training dates and the expiration dates. Is there a way to make a cell (the expiration date cell) turn yellow when it is within 6 months of expiring and red when it is within 1 month of expiring?
Trained Expiration
5/1/15 5/1/18
5/1/15 5/1/18
5/1/15 5/1/18
1/9/16 1/9/19
8/26/15 8/26/18
7/9/15 7/9/18
Bookmarks