Forum Discussion
Changing a different cell colour depending on date
See my previous reply
Jo Bloggs 25/04/2023
so this would be red and once it took place would automatically change green
Bloggs 24/05/2023
this would be yellow but if didn't happen for a month would automatically change colour or if it took place would change to green
Jo Bloggs 25/05/2023
this would be green but tomorrow would automatically change to yellow
Thanks, but how do we know whether it took place?
- I would change the date to the date that the supervision took place which should then automatically change to green
so red would be well overdue (ie a month), amber just overdue (a week or so) and green would be due or taken place!As far as I can tell, that wouldn't work the way you want. Let's take an example. Today is 25/05/2023.
A cell contain 20/04/2023. This is more than a month ago, so the cell is red.
Now the supervision takes place today, so you change the date to 25/05/2023. The cell automatically becomes green, as intended.
But tomorrow, 25/05/2023 is in the past, so the cell becomes yellow, and at the end of June, it would become red.
An alternative could be to enter a date in the future, for example the date the next supervision should take place, or if that is not applicable, a 31/12/2099 or so.
Or you could enter the date the supervision took place in another cell.
Do you have a preference?