Date ranges and symbols
I am looking for a formula to automatically change a symbol colour based on contract expiry dates. Here is what I need each symbol to signify about the expiry date column -
Green dot = If the contract expiry date is greater than 365 days from today
Yellow dot = If the contract expiry date is less than 365 days away from today
Blue Dot = if the date has past todays date
Red dot = box not populated
All help will be gratefully received.
It would also be cool to get up a notification when the symbols change colour.
Thanks in advance