Spreadsheet: 693182d1598833227-over-due-tasks-in-red-conditional-formatting-gantt-chart-operatons-gantt-example
Sheet: GanttChart

[NAME] Gantt
Assemble Communities
 |  | 2020-01-01 00:00:00 |  |  |  | Display Week | 36
WBS |  | LEAD | COMMENT | START | END | DAYS | % DONE | WORK DAYS
1.1 |  | DM | Test 1 | 2020-02-07 00:00:00 | 2020-02-07 00:00:00 |  | 1
 |  | DM | Test 2 | 2020-02-16 00:00:00 | 2020-02-16 00:00:00 |  | 1
 |  | DM | Test 3 | 2020-02-17 00:00:00 | 2020-02-29 00:00:00 |  | 1
 |  | DM/Panel | Test 4 | 2020-04-02 00:00:00 | 2020-04-03 00:00:00 |  | 1
 |  | DM | Test 5 | 2020-03-24 00:00:00 | 2020-03-31 00:00:00 |  | 1
 |  | DM | Test 6 | 2020-04-01 00:00:00 | 2020-04-30 00:00:00 |  | 1
 |  | DM | Test 7 | 2020-05-01 00:00:00 | 2020-05-15 00:00:00 |  | 1
 |  | DM | Test 8 | 2020-06-01 00:00:00 | 2020-06-30 00:00:00 |  | 1
 |  | DM | Test 9 | 2020-07-01 00:00:00 | 2020-09-15 00:00:00 |  | 0.5
 |  | DM | Test 10 | 2020-10-15 00:00:00 | 2020-12-31 00:00:00 |  | 0
 |  |  | Test 11
 |  | DM | Test 12 | 2020-01-13 00:00:00 | 2020-01-31 00:00:00 |  | 1
 |  | DM | Test 13 | 2020-02-04 00:00:00 | 2020-02-12 00:00:00 |  | 1
 |  | DM | Test 14 | 2020-01-31 00:00:00 | 2020-02-28 00:00:00 |  | 1
 |  |  | Test 15
 |  | DM | Test 16 | 2020-01-13 00:00:00 | 2020-06-30 00:00:00 |  | 1
 |  | DM | Test 17 | 2020-07-15 00:00:00 | 2020-08-31 00:00:00 |  | 0.45
 |  | DM | Test 18 | 2020-06-30 00:00:00 | 2020-10-30 00:00:00 |  | 0.5
 |  |  | Test 19
 |  | DM | Test 20 | 2020-01-15 00:00:00 | 2020-08-25 00:00:00 |  | 0.75
 |  | DM | Test 21 | 2020-08-27 00:00:00 | 2020-11-30 00:00:00 |  | 0
 |  | DM | Test 22 | 2021-01-01 00:00:00 | 2021-06-30 00:00:00 |  | 0
 |  | DM | Test 23 | 2020-04-01 00:00:00 | 2020-07-30 00:00:00 |  | 1
 |  | DM | Test 24 | 2021-01-01 00:00:00 | 2021-02-28 00:00:00 |  | 0
 |  | DM | Test 25 | 2020-08-01 00:00:00 | 2020-11-30 00:00:00 |  | 1
 |  | DM | Test 26 | 2020-07-01 00:00:00 | 2020-12-30 00:00:00 |  | 0.5
 |  | DM | Test 27 | 2020-05-29 00:00:00 | 2020-09-28 00:00:00 |  | 0.65
 |  | DM | Test 28 | 2021-02-01 00:00:00 | 2021-06-15 00:00:00 |  | 0
 |  | DM | Test 29 | 2020-04-01 00:00:00 | 2020-10-30 00:00:00 |  | 0.8
 |  | DM | Test 30 | 2020-07-01 00:00:00 | 2020-09-30 00:00:00 |  | 0.5
 |  | DM | Test 31 | 2020-07-01 00:00:00 | 2020-09-30 00:00:00 |  | 0.65
 |  | DM | Test 32 | 2020-05-01 00:00:00 | 2020-12-30 00:00:00 |  | 0.5
5 |  |  | Test 33
 |  | DM | Test 34 | 2020-02-01 00:00:00 | 2020-09-28 00:00:00 |  | 0.5
 |  | DM | Test 35 | 2020-03-30 00:00:00 | 2020-08-28 00:00:00 |  | 0.5
6 |  |  | Test 36
 |  | DM | Test 37 | 2020-02-01 00:00:00 | 2020-02-28 00:00:00 |  | 1
 |  | AG | Test 38 | 2020-02-01 00:00:00 | 2020-03-31 00:00:00 |  | 1
 |  | DM | Test 39 | TBC | TBC |  | 0
 |  | DM | Test 40 | 2020-04-15 00:00:00 | 2020-06-30 00:00:00 |  | 1
 |  | DM | Test 41 | 2020-05-01 00:00:00 | 2020-06-30 00:00:00 |  | 0.5
 |  | DM/AF | Test 42 | 2020-05-01 00:00:00 | 2020-06-15 00:00:00 |  | 1
 |  | TS/DM | Test 43 | TBC | TBC |  | 0.5
7 |  |  | Test 44
 |  | DM | Test 45 | 2020-02-01 00:00:00 | 2020-02-28 00:00:00 |  | 1
 |  | DM | Test 46 | 2020-02-01 00:00:00 | 2020-06-30 00:00:00 |  | 0.5
 |  | DM/MS/DN | Test 47 | 2020-02-01 00:00:00 | 2020-02-10 00:00:00 |  | 1
 |  | DM/MS/DN | Test 48 | 2020-02-01 00:00:00 | 2020-07-30 00:00:00 |  | 0.95
 |  | DM/MS/DN | Test 49 | 2020-08-01 00:00:00 | 2020-12-30 00:00:00 |  | 0
 |  | DM/MS/DN | Test 50 | 2021-01-01 00:00:00 | 2021-02-28 00:00:00 |  | 0
 |  | DM/MS/DN | Test 51 | 2021-03-01 00:00:00 | 2021-03-30 00:00:00 |  | 0
8 |  |  | Test 52
 |  | DM | Test 53 | 2021-01-01 00:00:00 | 2021-03-15 00:00:00 |  | 0.5
 |  | DM | Test 54 | 2020-12-01 00:00:00 | 2021-03-15 00:00:00 |  | 0
 |  | DM | Test 55 | 2020-10-01 00:00:00 | 2020-12-31 00:00:00 |  | 0
9 |  |  | Test 56
9.1 |  | DM | Test 57 | 2019-12-01 00:00:00 | 2020-03-31 00:00:00 |  | 1
 |  | DM | Test 58 | 2020-01-01 00:00:00 | 2020-03-31 00:00:00 |  | 1
 |  | DM | Test 59 | 2020-01-01 00:00:00 | 2020-05-25 00:00:00 |  | 1
 |  | DM | Test 60 | 2020-05-01 00:00:00 | 2020-05-31 00:00:00 |  | 1
 |  | DM | Test 61 | 2020-05-15 00:00:00 | 2020-06-15 00:00:00 |  | 1
 |  | DM | Test 62 | 2020-05-21 00:00:00 | 2020-06-30 00:00:00 |  | 0.5
 |  | DM/DN/ET | Test 63 | 2020-08-04 00:00:00 | 2020-08-31 00:00:00 |  | 0.5
10 |  |  | Test 64
10.1 |  | DM | Test 65 | 2020-05-01 00:00:00 | 2020-05-31 00:00:00 |  | 1
 |  | DM | Test 66 | 2020-06-16 00:00:00 | 2020-06-19 00:00:00 |  | 1
 |  | DM | Test 67 | 2020-09-02 00:00:00 | 2020-09-05 00:00:00 |  | 0
 |  | DM | Test 68 | 2020-06-18 00:00:00 | 2020-06-25 00:00:00 |  | 0.75
11 |  |  | Test 69
11.1 |  | DM | Test 70 | 2020-07-01 00:00:00 | 2020-07-03 00:00:00 |  | 1