Spreadsheet: 733350d1621520715-conditional-formatting-to-fill-cells-with-a-colour-between-to-dates-on-a-gant-chart-works-in-progress-tracker
Sheet: Manual Chart

Test
 | Calendar Start Date | 2021-05-01 00:00:00 |  |  |  |  | Week 1 |  |  |  |  |  |  | Week 2 |  |  |  |  |  |  | Week 3 |  |  |  |  |  |  | Week 4 |  |  |  |  |  |  | Week 5 |  |  |  |  |  |  | Week 6 |  |  |  |  |  |  | Week 7 |  |  |  |  |  |  | Week 8 |  |  |  |  |  |  | Week 9 |  |  |  |  |  |  | Week 10 |  |  |  |  |  |  | Week 11 |  |  |  |  |  |  | Week 12 |  |  |  |  |  |  | Week 13 |  |  |  |  |  |  | Week 14 |  |  |  |  |  |  | Week 15 |  |  |  |  |  |  | Week 16 |  |  |  |  |  |  | Week 17 |  |  |  |  |  |  | Week 18 |  |  |  |  |  |  | Week 19 |  |  |  |  |  |  | Week 20 |  |  |  |  |  |  | Week 21 |  |  |  |  |  |  | Week 22 |  |  |  |  |  |  | Week 23 |  |  |  |  |  |  | Week 24 |  |  |  |  |  |  | Week 25 |  |  |  |  |  |  | Week 26 |  |  |  |  |  |  | Week 27 |  |  |  |  |  |  | Week 28 |  |  |  |  |  |  | Week 29 |  |  |  |  |  |  | Week 30 |  |  |  |  |  |  | Week 31 |  |  |  |  |  |  | Week 32 |  |  |  |  |  |  | Week 33 |  |  |  |  |  |  | Week 34 |  |  |  |  |  |  | Week 35 |  |  |  |  |  |  | Week 36 |  |  |  |  |  |  | Week 37 |  |  |  |  |  |  | Week 38 |  |  |  |  |  |  | Week 39 |  |  |  |  |  |  | Week 40 |  |  |  |  |  |  | Week 41 |  |  |  |  |  |  | Week 42 |  |  |  |  |  |  | Week 43 |  |  |  |  |  |  | Week 44 |  |  |  |  |  |  | Week 45 |  |  |  |  |  |  | Week 46 |  |  |  |  |  |  | Week 47 |  |  |  |  |  |  | Week 48 |  |  |  |  |  |  | Week 49 |  |  |  |  |  |  | Week 50 |  |  |  |  |  |  | Week 51 |  |  |  |  |  |  | Week 52 |  |  |  |  |  |  | Week 1
 | TASK NAME | START DATE | END DATE | DURATION (WORK DAYS) | TEAM MEMBER | PERCENT COMPLETE
 | Project 1
 | Test | 2018-04-05 00:00:00 | 2018-04-08 00:00:00 |  |  | 1
 | Test | 2018-04-08 00:00:00 | 2018-04-10 00:00:00 |  |  | 0.8
 | Test | 2018-04-11 00:00:00 | 2018-04-16 00:00:00 |  |  | 0.6
 | Test | 2018-04-14 00:00:00 | 2018-04-18 00:00:00 |  |  | 0.4
 | Project 1
 | Test | 2018-04-05 00:00:00 | 2018-04-08 00:00:00 |  |  | 1
 | Test | 2018-04-08 00:00:00 | 2018-04-10 00:00:00 |  |  | 0.8
 | Test | 2018-04-11 00:00:00 | 2018-04-16 00:00:00 |  |  | 0.6
 | Test | 2018-04-14 00:00:00 | 2018-04-18 00:00:00 |  |  | 0.4
 | Project 1
 | Test | 2018-04-05 00:00:00 | 2018-04-08 00:00:00 |  |  | 1
 | Test | 2018-04-08 00:00:00 | 2018-04-10 00:00:00 |  |  | 0.8
 | Test | 2018-04-11 00:00:00 | 2018-04-16 00:00:00 |  |  | 0.6
 | Test | 2018-04-14 00:00:00 | 2018-04-18 00:00:00 |  |  | 0.4
 | Project 1
 | Test | 2018-04-05 00:00:00 | 2018-04-08 00:00:00 |  |  | 1
 | Test | 2018-04-08 00:00:00 | 2018-04-10 00:00:00 |  |  | 0.8
 | Test | 2018-04-11 00:00:00 | 2018-04-16 00:00:00 |  |  | 0.6
 | Test | 2018-04-14 00:00:00 | 2018-04-18 00:00:00 |  |  | 0.4
 | Project 1
 | Test | 2018-04-05 00:00:00 | 2018-04-08 00:00:00 |  |  | 1
 | Test | 2018-04-08 00:00:00 | 2018-04-10 00:00:00 |  |  | 0.8
 | Test | 2018-04-11 00:00:00 | 2018-04-16 00:00:00 |  |  | 0.6
 | Test | 2018-04-14 00:00:00 | 2018-04-18 00:00:00 |  |  | 0.4
 | Project 1
 | Test | 2018-04-05 00:00:00 | 2018-04-08 00:00:00 |  |  | 1
 | Test | 2018-04-08 00:00:00 | 2018-04-10 00:00:00 |  |  | 0.8
 | Test | 2018-04-11 00:00:00 | 2018-04-16 00:00:00 |  |  | 0.6
 | Test | 2018-04-14 00:00:00 | 2018-04-18 00:00:00 |  |  | 0.4
 | Project 1
 | Test | 2018-04-05 00:00:00 | 2018-04-08 00:00:00 |  |  | 1
 | Test | 2018-04-08 00:00:00 | 2018-04-10 00:00:00 |  |  | 0.8
 | Test | 2018-04-11 00:00:00 | 2018-04-16 00:00:00 |  |  | 0.6
 | Test | 2018-04-14 00:00:00 | 2018-04-18 00:00:00 |  |  | 0.4
 | Project 1
 | Test | 2018-04-05 00:00:00 | 2018-04-08 00:00:00 |  |  | 1
 | Test | 2018-04-08 00:00:00 | 2018-04-10 00:00:00 |  |  | 0.8
 | Test | 2018-04-11 00:00:00 | 2018-04-16 00:00:00 |  |  | 0.6
 | Test | 2018-04-14 00:00:00 | 2018-04-18 00:00:00 |  |  | 0.4
 | Project 1
 | Test | 2018-04-05 00:00:00 | 2018-04-08 00:00:00 |  |  | 1
 | Test | 2018-04-08 00:00:00 | 2018-04-10 00:00:00 |  |  | 0.8
 | Test | 2018-04-11 00:00:00 | 2018-04-16 00:00:00 |  |  | 0.6
 | Test | 2018-04-14 00:00:00 | 2018-04-18 00:00:00 |  |  | 0.4
 | Project 1
 | Test | 2018-04-05 00:00:00 | 2018-04-08 00:00:00 |  |  | 1
 | Test | 2018-04-08 00:00:00 | 2018-04-10 00:00:00 |  |  | 0.8
 | Test | 2018-04-11 00:00:00 | 2018-04-16 00:00:00 |  |  | 0.6
 | Test | 2018-04-14 00:00:00 | 2018-04-18 00:00:00 |  |  | 0.4
 | Project 1
 | Test | 2018-04-05 00:00:00 | 2018-04-08 00:00:00 |  |  | 1
 | Test | 2018-04-08 00:00:00 | 2018-04-10 00:00:00 |  |  | 0.8
 | Test | 2018-04-11 00:00:00 | 2018-04-16 00:00:00 |  |  | 0.6
 | Test | 2018-04-14 00:00:00 | 2018-04-18 00:00:00 |  |  | 0.4
 | Project 1
 | Test | 2018-04-05 00:00:00 | 2018-04-08 00:00:00 |  |  | 1
 | Test | 2018-04-08 00:00:00 | 2018-04-10 00:00:00 |  |  | 0.8
 | Test | 2018-04-11 00:00:00 | 2018-04-16 00:00:00 |  |  | 0.6
 | Test | 2018-04-14 00:00:00 | 2018-04-18 00:00:00 |  |  | 0.4
 | Project 1
 | Test | 2018-04-05 00:00:00 | 2018-04-08 00:00:00 |  |  | 1
 | Test | 2018-04-08 00:00:00 | 2018-04-10 00:00:00 |  |  | 0.8
 | Test | 2018-04-11 00:00:00 | 2018-04-16 00:00:00 |  |  | 0.6
 | Test | 2018-04-14 00:00:00 | 2018-04-18 00:00:00 |  |  | 0.4