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.
Where do I find the "Edit Formatting Rule"?
I found it under Conditional Formatting. It worked! Thanks so much!!!