Forum Discussion
How to change cells colours when an expiry date is coming to an end
belly101 Is this the one that you are looking for? Manual insert /change date will auto change the color.
You can use Conditional Formatting for that. See for example Conditional Formatting
If you would like more help, please provide some details about your setup.
Hello, thank you for the information but I am still confused. I can change the colour manually but I want to be able to put a date into the cell (when the training has been completed) then have the cell automatically change from green to amber (when the training is one month from the annual date) to red on the expiry date. I have seen this somewhere but can seem to find how to do this.
Please can you help?
Thank you
Lee
belly101 Is this the one that you are looking for? Manual insert /change date will auto change the color.
- How can we highlight the dates one month in advance, say in order to send reminders to subscribers... Like today date plus 30 days, if matched in a list, the date falling after 30 days should be highlighted.
- Good one liked this!
Where do I find the "Edit Formatting Rule"?
- I found it under Conditional Formatting. It worked! Thanks so much!!!
Could you attach a small sample workbook without sensitive/proprietary information that shows your setup?
- Name Fire Fisrt Aid GDPR 1 Infection Lone Medication M&H Safeguarding
J. Smith 23.06.21 25.07.21
P. JonesI'm afraid that doesn't help much.
