Would appreciate some help with the following -
We keep an Excel spreadsheet to track our suppliers insurance documents but need some help in setting up the Expired field.

The Column Heading is Expiry Date and in this field we capture the expiry date of the insurance certificate. I would like to automate this field by using a formula to look at the date in the field, comparing it to the current date and firstly to change the text to red 1 month before the expiry date and then to change the text in the field to "Expired" 1 day after the noted expiry date.

Is this something that can be done?
thank you
Alan