Spreadsheet: 84298d1284365745-how-to-auto-color-through-formulas-example
Sheet: example

 | Daily Progress Report
 | Day & Date: |  | 2010-09-01 00:00:00 |  | 2010-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-09-01 00:00:00
 | S.N. | Zone | Building | Description of Work Performed |  |  | Unit | Est. Qty. |  | S.N. | Zone | Building | Plan for Next Day | Unit | Est. Qty.
 |  |  |  |  |  |  |  | I m going to start my Daily Report from 1st sep 2010. I want to count my DCR numbers. Here I need, when I change date from cell (T4) it should highlight here like showing below the sheet. In hence I can continue this proedures.  Thanks…..
 |  |  |  |  | DCR No. | Date |  | Day
 |  |  |  |  | 1 | 2010-09-01 00:00:00 |  | Wednesday
 |  |  |  |  | 2 | 2010-09-02 00:00:00 |  | Thursday
 |  |  |  |  | 3 | 2010-09-03 00:00:00 |  | Friday
 |  |  |  |  | 4 | 2010-09-04 00:00:00 |  | Saturday
 |  |  |  |  | 5 | 2010-09-05 00:00:00 |  | Sunday
 |  |  |  |  | 6 | 2010-09-06 00:00:00 |  | Monday
 |  |  |  |  | 7 | 2010-09-07 00:00:00 |  | Tuesday
 |  |  |  |  | 8 | 2010-09-08 00:00:00 |  | Wednesday
 |  |  |  |  | 9 | 2010-09-09 00:00:00 |  | Thursday
 |  |  |  |  | 10 | 2010-09-10 00:00:00 |  | Friday
 |  |  |  |  | 11 | 2010-09-11 00:00:00 |  | Saturday
 |  |  |  |  | 12 | 2010-09-12 00:00:00 |  | Sunday
 |  |  |  |  | 13 | 2010-09-13 00:00:00 |  | Monday
 |  |  |  |  | 14 | 2010-09-14 00:00:00 |  | Tuesday
 |  |  |  |  | 15 | 2010-09-15 00:00:00 |  | Wednesday
 |  |  |  |  | 16 | 2010-09-16 00:00:00 |  | Thursday
 |  |  |  |  | 17 | 2010-09-17 00:00:00 |  | Friday
 |  |  |  |  | 18 | 2010-09-18 00:00:00 |  | Saturday
 |  |  |  |  | 19 | 2010-09-19 00:00:00 |  | Sunday
 |  |  |  |  | 20 | 2010-09-20 00:00:00 |  | Monday
 |  |  |  |  | 21 | 2010-09-21 00:00:00 |  | Tuesday
 |  |  |  |  | 22 | 2010-09-22 00:00:00 |  | Wednesday
 |  |  |  |  | 23 | 2010-09-23 00:00:00 |  | Thursday
 |  |  |  |  | 24 | 2010-09-24 00:00:00 |  | Friday
 |  |  |  |  | 25 | 2010-09-25 00:00:00 |  | Saturday
 |  |  |  |  | 26 | 2010-09-26 00:00:00 |  | Sunday
 |  |  |  |  | 27 | 2010-09-27 00:00:00 |  | Monday
 |  |  |  |  | 28 | 2010-09-28 00:00:00 |  | Tuesday
 |  |  |  |  | 29 | 2010-09-29 00:00:00 |  | Wednesday
 |  |  |  |  | 30 | 2010-09-30 00:00:00 |  | Thursday
 |  |  |  |  | 31 | 2010-10-01 00:00:00 |  | Friday
 |  |  |  |  | 32 | 2010-10-02 00:00:00 |  | Saturday
 |  |  |  |  | 33 | 2010-10-03 00:00:00 |  | Sunday
 |  |  |  |  | 34 | 2010-10-04 00:00:00 |  | Monday
 |  |  |  |  | 35 | 2010-10-05 00:00:00 |  | Tuesday
 |  |  |  |  | 36 | 2010-10-06 00:00:00 |  | Wednesday
 |  |  |  |  | 37 | 2010-10-07 00:00:00 |  | Thursday
 |  |  |  |  | 38 | 2010-10-08 00:00:00 |  | Friday
 |  |  |  |  | 39 | 2010-10-09 00:00:00 |  | Saturday
 |  |  |  |  | 40 | 2010-10-10 00:00:00 |  | Sunday
 |  |  |  |  | 41 | 2010-10-11 00:00:00 |  | Monday
 |  |  |  |  | 42 | 2010-10-12 00:00:00 |  | Tuesday
 |  |  |  |  | 43 | 2010-10-13 00:00:00 |  | Wednesday
 |  |  |  |  | 44 | 2010-10-14 00:00:00 |  | Thursday
 |  |  |  |  | 45 | 2010-10-15 00:00:00 |  | Friday
 |  |  |  |  | 46 | 2010-10-16 00:00:00 |  | Saturday
 |  |  |  |  | 47 | 2010-10-17 00:00:00 |  | Sunday
 |  |  |  |  | 48 | 2010-10-18 00:00:00 |  | Monday
 |  |  |  |  | 49 | 2010-10-19 00:00:00 |  | Tuesday
 |  |  |  |  | 50 | 2010-10-20 00:00:00 |  | Wednesday
 |  |  |  |  | 51 | 2010-10-21 00:00:00 |  | Thursday
 |  |  |  |  | 52 | 2010-10-22 00:00:00 |  | Friday
 |  |  |  |  | 53 | 2010-10-23 00:00:00 |  | Saturday
 |  |  |  |  | 54 | 2010-10-24 00:00:00 |  | Sunday
 |  |  |  |  | 55 | 2010-10-25 00:00:00 |  | Monday
 |  |  |  |  | 56 | 2010-10-26 00:00:00 |  | Tuesday
 |  |  |  |  | 57 | 2010-10-27 00:00:00 |  | Wednesday
 |  |  |  |  | 58 | 2010-10-28 00:00:00 |  | Thursday
 |  |  |  |  | 59 | 2010-10-29 00:00:00 |  | Friday
 |  |  |  |  | 60 | 2010-10-30 00:00:00 |  | Saturday
 |  |  |  |  | 61 | 2010-10-31 00:00:00 |  | Sunday
 |  |  |  |  | 62 | 2010-11-01 00:00:00 |  | Monday
 |  |  |  |  | 63 | 2010-11-02 00:00:00 |  | Tuesday
 |  |  |  |  | 64 | 2010-11-03 00:00:00 |  | Wednesday
 |  |  |  |  | 65 | 2010-11-04 00:00:00 |  | Thursday
 |  |  |  |  | 66 | 2010-11-05 00:00:00 |  | Friday
 |  |  |  |  | 67 | 2010-11-06 00:00:00 |  | Saturday
 |  |  |  |  | 68 | 2010-11-07 00:00:00 |  | Sunday
 |  |  |  |  | 69 | 2010-11-08 00:00:00 |  | Monday
 |  |  |  |  | 70 | 2010-11-09 00:00:00 |  | Tuesday
 |  |  |  |  | 71 | 2010-11-10 00:00:00 |  | Wednesday
 |  |  |  |  | 72 | 2010-11-11 00:00:00 |  | Thursday
 |  |  |  |  | 73 | 2010-11-12 00:00:00 |  | Friday
 |  |  |  |  | 74 | 2010-11-13 00:00:00 |  | Saturday
 |  |  |  |  | 75 | 2010-11-14 00:00:00 |  | Sunday
 |  |  |  |  | 76 | 2010-11-15 00:00:00 |  | Monday
 |  |  |  |  | 77 | 2010-11-16 00:00:00 |  | Tuesday
 |  |  |  |  | 78 | 2010-11-17 00:00:00 |  | Wednesday
 |  |  |  |  | 79 | 2010-11-18 00:00:00 |  | Thursday
 |  |  |  |  | 80 | 2010-11-19 00:00:00 |  | Friday
 |  |  |  |  | 81 | 2010-11-20 00:00:00 |  | Saturday
 |  |  |  |  | 82 | 2010-11-21 00:00:00 |  | Sunday
 |  |  |  |  | 83 | 2010-11-22 00:00:00 |  | Monday
 |  |  |  |  | 84 | 2010-11-23 00:00:00 |  | Tuesday
 |  |  |  |  | 85 | 2010-11-24 00:00:00 |  | Wednesday
 |  |  |  |  | 86 | 2010-11-25 00:00:00 |  | Thursday
 |  |  |  |  | 87 | 2010-11-26 00:00:00 |  | Friday
 |  |  |  |  | 88 | 2010-11-27 00:00:00 |  | Saturday
 |  |  |  |  | 89 | 2010-11-28 00:00:00 |  | Sunday
 |  |  |  |  | 90 | 2010-11-29 00:00:00 |  | Monday
 |  |  |  |  | 91 | 2010-11-30 00:00:00 |  | Tuesday
 |  |  |  |  | 92 | 2010-12-01 00:00:00 |  | Wednesday
 |  |  |  |  | 93 | 2010-12-02 00:00:00 |  | Thursday
 |  |  |  |  | 94 | 2010-12-03 00:00:00 |  | Friday
 |  |  |  |  | 95 | 2010-12-04 00:00:00 |  | Saturday
 |  |  |  |  | 96 | 2010-12-05 00:00:00 |  | Sunday
 |  |  |  |  | 97 | 2010-12-06 00:00:00 |  | Monday
 |  |  |  |  | 98 | 2010-12-07 00:00:00 |  | Tuesday
 |  |  |  |  | 99 | 2010-12-08 00:00:00 |  | Wednesday
 |  |  |  |  | 100 | 2010-12-09 00:00:00 |  | Thursday
 |  |  |  |  | 101
 |  |  |  |  | 102
 |  |  |  |  | 103
 |  |  |  |  | 104
 |  |  |  |  | 105
 |  |  |  |  | 106
 |  |  |  |  | 107
 |  |  |  |  | 108
 |  |  |  |  | 109
 |  |  |  |  | 110
 |  |  |  |  | 111
 |  |  |  |  | 112
 |  |  |  |  | 113
 |  |  |  |  | 114
 |  |  |  |  | 115
 |  |  |  |  | 116
 |  |  |  |  | 117
 |  |  |  |  | 118
 |  |  |  |  | 119
 |  |  |  |  | 120
 |  |  |  |  | 121
 |  |  |  |  | 122
 |  |  |  |  | 123
 |  |  |  |  | 124
 |  |  |  |  | 125
 |  |  |  |  | 126
 |  |  |  |  | 127
 |  |  |  |  | 128
 |  |  |  |  | 129
 |  |  |  |  | 130
 |  |  |  |  | 131
 |  |  |  |  | 132
 |  |  |  |  | 133
 |  |  |  |  | 134
 |  |  |  |  | 135
 |  |  |  |  | 136
 |  |  |  |  | 137
 |  |  |  |  | 138
 |  |  |  |  | 139
 |  |  |  |  | 140
 |  |  |  |  | 141
 |  |  |  |  | 142
 |  |  |  |  | 143
 |  |  |  |  | 144
 |  |  |  |  | 145
 |  |  |  |  | 146
 |  |  |  |  | 147
 |  |  |  |  | 148
 |  |  |  |  | 149
 |  |  |  |  | 150
 |  |  |  |  | 151
 |  |  |  |  | 152
 |  |  |  |  | 153
 |  |  |  |  | 154
 |  |  |  |  | 155
 |  |  |  |  | 156
 |  |  |  |  | 157
 |  |  |  |  | 158
 |  |  |  |  | 159
 |  |  |  |  | 160
 |  |  |  |  | 161
 |  |  |  |  | 162
 |  |  |  |  | 163
 |  |  |  |  | 164
 |  |  |  |  | 165
 |  |  |  |  | 166
 |  |  |  |  | 167
 |  |  |  |  | 168
 |  |  |  |  | 169
 |  |  |  |  | 170
 |  |  |  |  | 171
 |  |  |  |  | 172
 |  |  |  |  | 173
 |  |  |  |  | 174
 |  |  |  |  | 175
 |  |  |  |  | 176
 |  |  |  |  | 177
 |  |  |  |  | 178
 |  |  |  |  | 179
 |  |  |  |  | 180
 |  |  |  |  | 181
 |  |  |  |  | 182
 |  |  |  |  | 183
 |  |  |  |  | 184
 |  |  |  |  | 185
 |  |  |  |  | 186
 |  |  |  |  | 187
 |  |  |  |  | 188
 |  |  |  |  | 189
 |  |  |  |  | 190
 |  |  |  |  | 191
 |  |  |  |  | 192
 |  |  |  |  | 193
 |  |  |  |  | 194
 |  |  |  |  | 195
 |  |  |  |  | 196
 |  |  |  |  | 197
 |  |  |  |  | 198
 |  |  |  |  | 199
 |  |  |  |  | 200
 |  |  |  |  | 201
 |  |  |  |  | 202
 |  |  |  |  | 203
 |  |  |  |  | 204
 |  |  |  |  | 205
 |  |  |  |  | 206
 |  |  |  |  | 207
 |  |  |  |  | 208
 |  |  |  |  | 209
 |  |  |  |  | 210
 |  |  |  |  | 211
 |  |  |  |  | 212
 |  |  |  |  | 213
 |  |  |  |  | 214
 |  |  |  |  | 215
 |  |  |  |  | 216
 |  |  |  |  | 217
 |  |  |  |  | 218
 |  |  |  |  | 219
 |  |  |  |  | 220
 |  |  |  |  | 221
 |  |  |  |  | 222
 |  |  |  |  | 223
 |  |  |  |  | 224
 |  |  |  |  | 225
 |  |  |  |  | 226
 |  |  |  |  | 227
 |  |  |  |  | 228
 |  |  |  |  | 229
 |  |  |  |  | 230
 |  |  |  |  | 231
 |  |  |  |  | 232
 |  |  |  |  | 233
 |  |  |  |  | 234
 |  |  |  |  | 235
 |  |  |  |  | 236
 |  |  |  |  | 237
 |  |  |  |  | 238
 |  |  |  |  | 239
 |  |  |  |  | 240
 |  |  |  |  | 241
 |  |  |  |  | 242
 |  |  |  |  | 243
 |  |  |  |  | 244
 |  |  |  |  | 245
 |  |  |  |  | 246
 |  |  |  |  | 247
 |  |  |  |  | 248
 |  |  |  |  | 249
 |  |  |  |  | 250
 |  |  |  |  | 251
 |  |  |  |  | 252
 |  |  |  |  | 253
 |  |  |  |  | 254
 |  |  |  |  | 255
 |  |  |  |  | 256
 |  |  |  |  | 257
 |  |  |  |  | 258
 |  |  |  |  | 259
 |  |  |  |  | 260
 |  |  |  |  | 261
 |  |  |  |  | 262
 |  |  |  |  | 263
 |  |  |  |  | 264
 |  |  |  |  | 265
 |  |  |  |  | 266
 |  |  |  |  | 267
 |  |  |  |  | 268
 |  |  |  |  | 269
 |  |  |  |  | 270
 |  |  |  |  | 271
 |  |  |  |  | 272
 |  |  |  |  | 273
 |  |  |  |  | 274
 |  |  |  |  | 275
 |  |  |  |  | 276
 |  |  |  |  | 277
 |  |  |  |  | 278
 |  |  |  |  | 279
 |  |  |  |  | 280
 |  |  |  |  | 281
 |  |  |  |  | 282
 |  |  |  |  | 283
 |  |  |  |  | 284
 |  |  |  |  | 285
 |  |  |  |  | 286
 |  |  |  |  | 287
 |  |  |  |  | 288
 |  |  |  |  | 289
 |  |  |  |  | 290
 |  |  |  |  | 291
 |  |  |  |  | 292
 |  |  |  |  | 293
 |  |  |  |  | 294
 |  |  |  |  | 295
 |  |  |  |  | 296
 |  |  |  |  | 297
 |  |  |  |  | 298
 |  |  |  |  | 299
 |  |  |  |  | 300
 |  |  |  |  | 301
 |  |  |  |  | 302
 |  |  |  |  | 303
 |  |  |  |  | 304
 |  |  |  |  | 305
 |  |  |  |  | 306
 |  |  |  |  | 307
 |  |  |  |  | 308
 |  |  |  |  | 309
 |  |  |  |  | 310
 |  |  |  |  | 311
 |  |  |  |  | 312
 |  |  |  |  | 313
 |  |  |  |  | 314
 |  |  |  |  | 315
 |  |  |  |  | 316
 |  |  |  |  | 317
 |  |  |  |  | 318
 |  |  |  |  | 319
 |  |  |  |  | 320
 |  |  |  |  | 321
 |  |  |  |  | 322
 |  |  |  |  | 323
 |  |  |  |  | 324
 |  |  |  |  | 325
 |  |  |  |  | 326
 |  |  |  |  | 327
 |  |  |  |  | 328
 |  |  |  |  | 329
 |  |  |  |  | 330
 |  |  |  |  | 331
 |  |  |  |  | 332
 |  |  |  |  | 333
 |  |  |  |  | 334
 |  |  |  |  | 335
 |  |  |  |  | 336
 |  |  |  |  | 337
 |  |  |  |  | 338
 |  |  |  |  | 339
 |  |  |  |  | 340
 |  |  |  |  | 341
 |  |  |  |  | 342
 |  |  |  |  | 343
 |  |  |  |  | 344
 |  |  |  |  | 345
 |  |  |  |  | 346
 |  |  |  |  | 347
 |  |  |  |  | 348
 |  |  |  |  | 349
 |  |  |  |  | 350
 |  |  |  |  | 351
 |  |  |  |  | 352
 |  |  |  |  | 353
 |  |  |  |  | 354
 |  |  |  |  | 355
 |  |  |  |  | 356
 |  |  |  |  | 357
 |  |  |  |  | 358
 |  |  |  |  | 359
 |  |  |  |  | 360
 |  |  |  |  | 361
 |  |  |  |  | 362
 |  |  |  |  | 363
 |  |  |  |  | 364
 |  |  |  |  | 365
 |  |  |  |  | 366
 |  |  |  |  | 367
 |  |  |  |  | 368
 |  |  |  |  | 369
 |  |  |  |  | 370
 |  |  |  |  | 371
 |  |  |  |  | 372
 |  |  |  |  | 373
 |  |  |  |  | 374
 |  |  |  |  | 375
 |  |  |  |  | 376
 |  |  |  |  | 377
 |  |  |  |  | 378
 |  |  |  |  | 379
 |  |  |  |  | 380
 |  |  |  |  | 381
 |  |  |  |  | 382
 |  |  |  |  | 383
 |  |  |  |  | 384
 |  |  |  |  | 385
 |  |  |  |  | 386
 |  |  |  |  | 387
 |  |  |  |  | 388
 |  |  |  |  | 389
 |  |  |  |  | 390
 |  |  |  |  | 391
 |  |  |  |  | 392
 |  |  |  |  | 393
 |  |  |  |  | 394
 |  |  |  |  | 395
 |  |  |  |  | 396
 |  |  |  |  | 397
 |  |  |  |  | 398
 |  |  |  |  | 399
 |  |  |  |  | 400
 |  |  |  |  | 401
 |  |  |  |  | 402