Hello all, in a bit of a pickle. I need the column "UGT Due Date" to turn yellow when 30-90 days closing in on it. then on the 91st day and past or when we get to it to turn Red. Any time before that Green. I know that all in this particular example would be red since the date is past or coming in. Please assist. Thank you for your time.
Start Date | EOC/10-Day/Practical | Days Enrolled | UGT Due Date |
3/1/2021 | Practical Scheduled | 267 | 1-Sep-21 |
4/21/2021 | CDC Started | 216 | 26-Nov-21 |
7/21/2021 | EOC Taken | 125 | 26-Nov-21 |
8/4/2021 | Practical Scheduled | 111 | 1-Sep-21 |
10/21/2021 | CDC Started | 33 | 26-Nov-21 |