Date ranges and symbols

04/17/19 Edited 12/09/19

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

Richard

Comments

Sign In or Register to comment.