Forum Discussion
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.
17 Replies
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.
Hans
I have a similar question, and the answer may assist.
I would like to change the colour of a cell, depending on the context of another cell.
Possibly and if statement -
if(A1>100, set Cell A1 fillcolor to green, set Cell A1 Fillcolor to Red)
Now, I have used 'set Cell Fillcolor to ... and this is what I would like clarified, what should that be?
Thanks in anticipation
You write
I would like to change the colour of a cell, depending on the context of another cell.
but you then mention only cell A1...
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.
