I wonder if anyone can help me I have a spreadsheet, that I need to have cells that change colour when dates are close.
Please see below. What I have been trying to do is to take the date in cell Eas a start date and make cell F change colour to green for the next 80 days and then turn amber for the 10 days prior to the date in cell F. then depending if the date in cell e has been updated the cell will either revert to green or turn red. All help with this will be very much appreciated.
Thank you in advance.
Please see below. What I have been trying to do is to take the date in cell Eas a start date and make cell F change colour to green for the next 80 days and then turn amber for the 10 days prior to the date in cell F. then depending if the date in cell e has been updated the cell will either revert to green or turn red. All help with this will be very much appreciated.
Thank you in advance.
A | B | C | D | E | F | G | H | |
Support Worker | Resident Name | Address | TSD (Tenancy Start Date) | Risk Assessment Completion Date |
| Support Plan Completion Date | Support Plan Review date | |
Tracey | Jordon Chew | Rm 1, 208 Nechells Park Road, Nechells, Birmingham, B7 5SP | 09/02/2023 | 01/01/2023 | 01/04/2023 | 01/01/2023 | 01/04/2023 | |
Tracey | Lyndon Young | Rm 2, 208 Nechells Park Road, Nechells, Birmingham, B7 5SP | 20/12/2021 | |||||
Tracey | Arnold Gasana | Rm 3, 208 Nechells Park Road, Nechells, Birmingham, B7 5SP | 10/02/2023 |