Forum Discussion
Changing a different cell colour depending on date
I am creating a spreadsheet with Clients info. I have their information stored in Excel but want to make their name cell change colour when I have a meeting with them on a specific date. I have t...
Could you post a screenshot of your worksheet (without real names and data)?
Or even better, attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
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
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 yellow
