Forum Discussion
Re: Changing a different cell colour depending on date
I am working on an excel document and would like to use the traffic light system an example a supervision was due April and it hasn't take place it would turn to red automatically, if one was due today it would be green but would turn yellow next week if it hadn't taken place
7 Replies
See my previous reply
- Supervision Due
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 yellowThanks, but how do we know whether it took place?
