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.
I'm afraid that doesn't help much.
I am sorry that I am such a neanderthal š
I just want to make a spreadsheet where the cell automatically change when the mandatory training is nearing expiration and then again when they have expired,
Thank you for any help you can give
Lee
I just want to make a spreadsheet where the cell automatically change when the mandatory training is nearing expiration and then again when they have expired,
Thank you for any help you can give
Lee
You can attach a sample workbook to a reply simply by dragging the workbook file into the box below the space where you compose a reply.
ā