I created a spreadsheet to track down volunteers based on their training/certification. I have tried multiple methods and going through different options to get this right, but so far It's not working.
There are 3 conditions I would like to apply to cell M3:
If cell value L3 is two years or more than TODAY's date, highlight M3 red.
If cell value L3 is one year to a day before two years from TODAY's date, highlight M3 yellow.
If Cell value L3 is less than a year from TODAY's date, highlight M3 green.
I have attached my spreadsheet for a better visual. In the future, I would like to use icons (i.e. Green check mark, yellow exclamation, and red X) instead of just highlighting the cell.
Any input is greatly appreciated. Thanks in advance.
Bookmarks