Hi Everyone,
I work for an Agency that outsources Renovation and Fumigation Services. Agreements are usually entered for every contract issued. The Legal Unit requested that I design a simple Excel Sheets that will notify them when a contract is about to expire, subsisting or has expired. I have done so using conditional formatting. Working with the date entered in the EXPIRY DATE Column, the color changes (see attached):
1. To WHITE If the contract is ongoing,
2. To YELLOW if the contract has two weeks to expire,
3. To RED if the contract has Expired.
However, I would want the STATUS column to change as follows
1. Indicate "ONGOING" for every contract that is currently ONGOING,
2. Indicate "ABOUT TO EXPIRE" for contracts that has two weeks to EXPIRE and finally,
3. Indicate EXPIRED for every contract that has expired.
Can someone please assist.
Thank you in advance.