Spreadsheet: 103632d1301379765-help-in-conditional-formatting-copy-of-xl0000035
Sheet: Concrete Reports 

Emergency Lodging Centre Project, Shumaisi
Concrete Report
S.No. | Date | Location | Concrete Type | Units | Quantity of PC | Quantity of RC
1 | 2010-09-28 00:00:00 | Water Tank No. 10 | PC | m3 | 55 |  |  | Here I want help in conditional formatting which will be as follow :
2 | 2010-09-30 00:00:00 | Water Tank No. 10 | PC | m3 | 33
3 | 2010-10-20 00:00:00 | Water Tank No. 10 | PC | m3 | 157 |  |  | I have 2 types of Conrete which is PC (Plain Concrete) & RC (Reinforced Concrete)
4 | 2010-10-21 00:00:00 | Water Tank No. 10 | PC | m3 | 63
5 | 2010-10-24 00:00:00 | Water Tank No. 10 | PC | m3 | 92 |  |  | While Filling date lest say in the Cell D30 RC so I want it should become red it self & G30 as well.
6 | 2010-10-27 00:00:00 | Water Tank No. 10 | PC | m3 | 65
7 | 2010-11-02 00:00:00 | Water Tank No. 8 | PC | m3 | 22
8 | 2010-11-04 00:00:00 | Water Tank No. 8 | PC | m3 | 80
9 | 2010-11-06 00:00:00 | Water Tank No. 8 | PC | m3 | 62
10 | 2010-11-08 00:00:00 | Water Tank No. 8 | PC | m3 | 146
11 | 2010-11-23 00:00:00 | Water Tank No. 10 | PC | m3 | 44
12 | 2010-11-24 00:00:00 | Water Tank No. 10 | PC | m3 | 86
13 | 2010-11-25 00:00:00 | Water Tank No. 11 | PC | m3 | 62
14 | 2010-12-04 00:00:00 | Water Tank No. 8 | PC | m3 | 55
15 | 2010-12-05 00:00:00 | Water Tank No. 8 | PC | m3 | 92
16 | 2010-12-09 00:00:00 | Foundation of MHs | PC | m3 | 10
17 | 2010-12-12 00:00:00 | Water Tank No.01 | PC | m3 | 120
18 | 2010-12-16 00:00:00 | Water Tank No.06 | PC | m3 | 55
19 | 2010-12-18 00:00:00 | Earth Manhole | PC | m3 | 4
20 | 2010-12-21 00:00:00 | Water Tank No.01 | PC | m3 | 56
21 | 2010-12-21 00:00:00 | Water Tank No.06 | PC | m3 | 20
22 | 2010-12-22 00:00:00 | Manhole | PC | m3 | 5
23 | 2010-12-25 00:00:00 | Water Tank No.07 | PC | m3 | 86
24 | 2010-12-26 00:00:00 | Water Tank No. 10 | RC | m3 |  | 655
25 | 2010-12-28 00:00:00 | Manhole | PC | m3 | 18
26 | 2011-01-03 00:00:00 | Water Tank No.4 | PC | m3 | 87
27 | 2011-01-04 00:00:00 | Water Tank No.4 | PC | m3 | 110
28 | 2011-01-04 00:00:00 | Water Tank No.8 | RC | m3 |  | 245
29 | 2011-01-05 00:00:00 | Water Tank No.4 | PC | m3 | 99
30 | 2011-01-08 00:00:00 | Boundary Wall  (1 to 16) | PC | m3 | 17
31 | 2011-01-08 00:00:00 | Water Tank No.4 | PC | m3 | 150
32 | 2011-01-09 00:00:00 | Water Tank No.4 | PC | m3 | 40
33 | 2011-01-10 00:00:00 | Boundary Wall (16 to 36) | PC | m3 | 30
34 | 2011-01-10 00:00:00 | Water Tank No. 10 | RC | m3 |  | 244
35 | 2011-01-12 00:00:00 | Water Tank No.7 | PC | m3 | 53
36 | 2011-01-13 00:00:00 | Manhole | PC | m3 | 19
37 | 2011-01-18 00:00:00 | Water Tank No.4 | PC | m3 | 279
38 | 2011-01-20 00:00:00 | Water Tank No. 10 | PC | m3 | 61
39 | 2011-01-22 00:00:00 | Water Tank No.8 | PC | m3 | 85
40 | 2011-01-24 00:00:00 | Water Tank No.2 | PC | m3 | 62
41 | 2011-01-25 00:00:00 | Water Tank No.2 | PC | m3 | 100
42 | 2011-01-27 00:00:00 | Water Tank No.2 | PC | m3 | 100
43 | 2011-01-29 00:00:00 | Water Tank No.2 | PC | m3 | 94
44 | 2011-01-31 00:00:00 | Water Tank No.8 | RC | m3 |  | 600
45 | 2011-01-31 00:00:00 | Boundary Wall (55 to 75) | PC | m3 | 25
46 | 2011-02-02 00:00:00 | Water Tank No. 2 | PC | m3 | 60
47 | 2011-02-03 00:00:00 | Boundary Wall Road E (49-58) | PC | m3 | 27
48 | 2011-02-06 00:00:00 | Water Tank No. 7 | PC | m3 | 9
49 | 2011-02-06 00:00:00 | Water Tank No. 1 | PC | m3 | 9
50 | 2011-02-06 00:00:00 | Water Tank No. 6 | PC | m3 | 9
51 | 2011-02-08 00:00:00 | Boundary Wall Road E (48-15) | PC | m3 | 50
52 | 2011-02-08 00:00:00 | Water Tank No. 10 | PC | m3 | 41
53 | 2011-02-10 00:00:00 | Boundary Wall Road E (85-39) | PC | m3 | 65
54 | 2011-02-10 00:00:00 | Water Tank No. 7 | PC | m3 | 10
55 | 2011-02-13 00:00:00 | Baundary Wall | PC | m3 | 40
56 | 2011-02-13 00:00:00 | Foundation of MHs | PC | m3 | 16
57 | 2011-02-13 00:00:00 | Tank No.4 | PC | m3 | 51
58 | 2011-02-13 00:00:00 | Baundary Wall 68 to 75 | RC | m3 |  | 40
59 | 2011-02-13 00:00:00 | Water Tank No.6 | PC | m3 | 7
60 | 2011-02-14 00:00:00 | Water Tank No.4 | PC | m3 | 70
61 | 2011-02-14 00:00:00 | [NAME] (95 to107) | PC | m3 | 20
62 | 2011-02-15 00:00:00 | [NAME]4-14) | PC | m3 | 15
63 | 2011-02-15 00:00:00 | Water Tank No. 4 | PC | m3 | 30
64 | 2011-02-16 00:00:00 | Water Tank No. 4 | PC | m3 | 183
65 | 2011-02-16 00:00:00 | [NAME] (68 - 45) | RC | m3 |  | 120
66 | 2011-02-16 00:00:00 | [NAME] (120 - 155) | PC | m3 | 30
67 | 2011-02-17 00:00:00 | [NAME] (84 to119) | PC | m3 | 30
68 | 2011-02-17 00:00:00 | Water Tank No.4 | PC | m3 | 70
69 | 2011-02-17 00:00:00 | Water Tank No. 10 | PC | m3 | 14
70 | 2011-02-20 00:00:00 | Water Tank No.4 | PC | m3 | 44
71 | 2011-02-22 00:00:00 | Water Tank No.2 | PC | m3 | 120
72 | 2011-02-22 00:00:00 | Water Tank No.8 | PC | m3 | 7
73 | 2011-02-22 00:00:00 | Boundary Wall (83 to 46) | PC | m3 | 30
74 | 2011-02-23 00:00:00 | Water Tank No.8 | RC | m3 |  | 670
75 | 2011-02-24 00:00:00 | Boundary Wall (F1 to 44) | PC | m3 | 40
76 | 2011-02-24 00:00:00 | Water Tank No.2 | PC | m3 | 100
77 | 2011-02-26 00:00:00 | Boundary Wall (43 to 14) Road E | RC | m3 |  | 145
78 | 2011-02-28 00:00:00 | Water Tank No. 7 | RC | m3 |  | 449
79 | 2011-03-01 00:00:00 | Boundary Wall (13 to4) Road E | RC | m3 |  | 60
80 | 2011-03-01 00:00:00 | Water Tank No.10(  Column) | RC | m3 |  | 8
81 | 2011-03-01 00:00:00 | Boundary Wall(42 to1)Road A | PC | m3 | 35
82 | 2011-03-03 00:00:00 | Water Tank No.6 | RC | m3 |  | 296
83 | 2011-03-03 00:00:00 | Boundary Wall(153 to 162) Road A | PC | m3 | 15
82 | 2011-03-05 00:00:00 | Boundary Wall(127 to 152) Road A | PC | m3 | 40
83 | 2011-03-06 00:00:00 | Water Tank No.8 | RC | m3 |  | 16
84 | 2011-03-06 00:00:00 | Boundary Wall(95 to 107) Road A | RC | m3 |  | 801
85 | 2011-03-06 00:00:00 | Electrical Piping | PC | m3 | 64
86 | 2011-03-07 00:00:00 | Water Tank No.1 | RC | m3 |  | 488
87 | 2011-03-12 00:00:00 | Electrical | PC | m3 | 43
88 | 2011-03-12 00:00:00 | Water Tank No. 10 | RC | m3 |  | 0.3
89 | 2011-03-12 00:00:00 | Boundary Wall(37 to 65) Road E | RC | m3 |  | 12
90 | 2011-03-13 00:00:00 | Water Tank No. 10 | RC | m3 |  | 585
91 | 2011-03-13 00:00:00 | Water Tank No.08 | RC | m3 |  | 14
92 | 2011-03-15 00:00:00 | Electrical Piping | PC | m3 | 43
93 | 2011-03-15 00:00:00 | Boundary Wall (208 to 220) Zone 3 | PC | m3 | 60
94 | 2011-03-16 00:00:00 | Boundary Wall (149 to 127) Road A | RC | m3 |  | 110
95 | 2011-03-19 00:00:00 | Duct Bank Road B | PC | m3 | 9
96 | 2011-03-20 00:00:00 | Column Camp at Road E | RC | m3 |  | 20
97 | 2011-03-20 00:00:00 | Columns for Boundary Wall #10 | RC | m3 |  | 19
98 | 2011-03-22 00:00:00 | Manhole (Line F) | PC | m3 | 22
99 | 2011-03-23 00:00:00 | Duct bank | PC | m3 | 34
103 | 2011-03-26 00:00:00 | Boundary Wall (46 to 67), (207 to 181) at Zone 3 | PC | m3 | 65
100 | 2011-03-27 00:00:00 | Footing of Boundary Wall (150 to 162) Road A | RC | m3 |  | 80
101 | 2011-03-27 00:00:00 | Manhole | PC | m3 | 10
102 | 2011-03-27 00:00:00 | Electrical Duct Bank | PC | m3 | 17
Total  Quantity of Plain Concrete   (m3) |  |  |  |  | 4553 |  | 295945
Total Quantity of Reinforcement Concrete   (m3) |  |  |  |  |  | 5677.3 | 5853296.3