Forum Discussion
Solved
How to change cells colours when an expiry date is coming to an end
I am trying to make a training spreadsheet that has the cells change colour depending on how near the training is to expiring. Please can anyone help Thank you in anticipation
belly101 Is this the one that you are looking for? Manual insert /change date will auto change the color.
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.