Spreadsheet: 186630d1350127739-problem-in-conditional-formating-leave-record-with-conditional-formating-formula-
Sheet: Sheet1

Sr. # | Emp # | Name | Designation | Section |  |  |  | SEPTEMBER-2012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCTOBER-2012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOVEMBER-2012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DECEMBER-2012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JANUARY-2012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F'FEBRUARY-2012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MARCH-2012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APRIL-2012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY-2012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUNE-2012
 |  |  |  |  |  |  |  | 2012-09-01 00:00:00 | 2012-09-02 00:00:00 | 2012-09-03 00:00:00 | 2012-09-04 00:00:00 | 2012-09-05 00:00:00 | 2012-09-06 00:00:00 | 2012-09-07 00:00:00 | 2012-09-08 00:00:00 | 2012-09-09 00:00:00 | 2012-09-10 00:00:00 | 2012-09-11 00:00:00 | 2012-09-12 00:00:00 | 2012-09-13 00:00:00 | 2012-09-14 00:00:00 | 2012-09-15 00:00:00 | 2012-09-16 00:00:00 | 2012-09-17 00:00:00 | 2012-09-18 00:00:00 | 2012-09-19 00:00:00 | 2012-09-20 00:00:00 | 2012-09-21 00:00:00 | 2012-09-22 00:00:00 | 2012-09-23 00:00:00 | 2012-09-24 00:00:00 | 2012-09-25 00:00:00 | 2012-09-26 00:00:00 | 2012-09-27 00:00:00 | 2012-09-28 00:00:00 | 2012-09-29 00:00:00 | 2012-09-30 00:00:00 | 2012-10-01 00:00:00 | 2012-10-02 00:00:00 | 2012-10-03 00:00:00 | 2012-10-04 00:00:00 | 2012-10-05 00:00:00 | 2012-10-06 00:00:00 | 2012-10-07 00:00:00 | 2012-10-08 00:00:00 | 2012-10-09 00:00:00 | 2012-10-10 00:00:00 | 2012-10-11 00:00:00 | 2012-10-12 00:00:00 | 2012-10-13 00:00:00 | 2012-10-14 00:00:00 | 2012-10-15 00:00:00 | 2012-10-16 00:00:00 | 2012-10-17 00:00:00 | 2012-10-18 00:00:00 | 2012-10-19 00:00:00 | 2012-10-20 00:00:00 | 2012-10-21 00:00:00 | 2012-10-22 00:00:00 | 2012-10-23 00:00:00 | 2012-10-24 00:00:00 | 2012-10-25 00:00:00 | 2012-10-26 00:00:00 | 2012-10-27 00:00:00 | 2012-10-28 00:00:00 | 2012-10-29 00:00:00 | 2012-10-30 00:00:00 | 2012-10-31 00:00:00 | 2012-11-01 00:00:00 | 2012-11-02 00:00:00 | 2012-11-03 00:00:00 | 2012-11-04 00:00:00 | 2012-11-05 00:00:00 | 2012-11-06 00:00:00 | 2012-11-07 00:00:00 | 2012-11-08 00:00:00 | 2012-11-09 00:00:00 | 2012-11-10 00:00:00 | 2012-11-11 00:00:00 | 2012-11-12 00:00:00 | 2012-11-13 00:00:00 | 2012-11-14 00:00:00 | 2012-11-15 00:00:00 | 2012-11-16 00:00:00 | 2012-11-17 00:00:00 | 2012-11-18 00:00:00 | 2012-11-19 00:00:00 | 2012-11-20 00:00:00 | 2012-11-21 00:00:00 | 2012-11-22 00:00:00 | 2012-11-23 00:00:00 | 2012-11-24 00:00:00 | 2012-11-25 00:00:00 | 2012-11-26 00:00:00 | 2012-11-27 00:00:00 | 2012-11-28 00:00:00 | 2012-11-29 00:00:00 | 2012-11-30 00:00:00 | 2012-12-01 00:00:00 | 2012-12-02 00:00:00 | 2012-12-03 00:00:00 | 2012-12-04 00:00:00 | 2012-12-05 00:00:00 | 2012-12-06 00:00:00 | 2012-12-07 00:00:00 | 2012-12-08 00:00:00 | 2012-12-09 00:00:00 | 2012-12-10 00:00:00 | 2012-12-11 00:00:00 | 2012-12-12 00:00:00 | 2012-12-13 00:00:00 | 2012-12-14 00:00:00 | 2012-12-15 00:00:00 | 2012-12-16 00:00:00 | 2012-12-17 00:00:00 | 2012-12-18 00:00:00 | 2012-12-19 00:00:00 | 2012-12-20 00:00:00 | 2012-12-21 00:00:00 | 2012-12-22 00:00:00 | 2012-12-23 00:00:00 | 2012-12-24 00:00:00 | 2012-12-25 00:00:00 | 2012-12-26 00:00:00 | 2012-12-27 00:00:00 | 2012-12-28 00:00:00 | 2012-12-29 00:00:00 | 2012-12-30 00:00:00 | 2012-12-31 00:00:00 | 2013-01-01 00:00:00 | 2013-01-02 00:00:00 | 2013-01-03 00:00:00 | 2013-01-04 00:00:00 | 2013-01-05 00:00:00 | 2013-01-06 00:00:00 | 2013-01-07 00:00:00 | 2013-01-08 00:00:00 | 2013-01-09 00:00:00 | 2013-01-10 00:00:00 | 2013-01-11 00:00:00 | 2013-01-12 00:00:00 | 2013-01-13 00:00:00 | 2013-01-14 00:00:00 | 2013-01-15 00:00:00 | 2013-01-16 00:00:00 | 2013-01-17 00:00:00 | 2013-01-18 00:00:00 | 2013-01-19 00:00:00 | 2013-01-20 00:00:00 | 2013-01-21 00:00:00 | 2013-01-22 00:00:00 | 2013-01-23 00:00:00 | 2013-01-24 00:00:00 | 2013-01-25 00:00:00 | 2013-01-26 00:00:00 | 2013-01-27 00:00:00 | 2013-01-28 00:00:00 | 2013-01-29 00:00:00 | 2013-01-30 00:00:00 | 2013-01-31 00:00:00 | 2013-02-01 00:00:00 | 2013-02-02 00:00:00 | 2013-02-03 00:00:00 | 2013-02-04 00:00:00 | 2013-02-05 00:00:00 | 2013-02-06 00:00:00 | 2013-02-07 00:00:00 | 2013-02-08 00:00:00 | 2013-02-09 00:00:00 | 2013-02-10 00:00:00 | 2013-02-11 00:00:00 | 2013-02-12 00:00:00 | 2013-02-13 00:00:00 | 2013-02-14 00:00:00 | 2013-02-15 00:00:00 | 2013-02-16 00:00:00 | 2013-02-17 00:00:00 | 2013-02-18 00:00:00 | 2013-02-19 00:00:00 | 2013-02-20 00:00:00 | 2013-02-21 00:00:00 | 2013-02-22 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00 | 2013-02-27 00:00:00 | 2013-02-28 00:00:00 | 2013-03-01 00:00:00 | 2013-03-02 00:00:00 | 2013-03-03 00:00:00 | 2013-03-04 00:00:00 | 2013-03-05 00:00:00 | 2013-03-06 00:00:00 | 2013-03-07 00:00:00 | 2013-03-08 00:00:00 | 2013-03-09 00:00:00 | 2013-03-10 00:00:00 | 2013-03-11 00:00:00 | 2013-03-12 00:00:00 | 2013-03-13 00:00:00 | 2013-03-14 00:00:00 | 2013-03-15 00:00:00 | 2013-03-16 00:00:00 | 2013-03-17 00:00:00 | 2013-03-18 00:00:00 | 2013-03-19 00:00:00 | 2013-03-20 00:00:00 | 2013-03-21 00:00:00 | 2013-03-22 00:00:00 | 2013-03-23 00:00:00 | 2013-03-24 00:00:00 | 2013-03-25 00:00:00 | 2013-03-26 00:00:00 | 2013-03-27 00:00:00 | 2013-03-28 00:00:00 | 2013-03-29 00:00:00 | 2013-03-30 00:00:00 | 2013-03-31 00:00:00 | 2013-04-01 00:00:00 | 2013-04-02 00:00:00 | 2013-04-03 00:00:00 | 2013-04-04 00:00:00 | 2013-04-05 00:00:00 | 2013-04-06 00:00:00 | 2013-04-07 00:00:00 | 2013-04-08 00:00:00 | 2013-04-09 00:00:00 | 2013-04-10 00:00:00 | 2013-04-11 00:00:00 | 2013-04-12 00:00:00 | 2013-04-13 00:00:00 | 2013-04-14 00:00:00 | 2013-04-15 00:00:00 | 2013-04-16 00:00:00 | 2013-04-17 00:00:00 | 2013-04-18 00:00:00 | 2013-04-19 00:00:00 | 2013-04-20 00:00:00 | 2013-04-21 00:00:00 | 2013-04-22 00:00:00 | 2013-04-23 00:00:00 | 2013-04-24 00:00:00 | 2013-04-25 00:00:00 | 2013-04-26 00:00:00 | 2013-04-27 00:00:00 | 2013-04-28 00:00:00 | 2013-04-29 00:00:00 | 2013-04-30 00:00:00 | 2013-05-01 00:00:00 | 2013-05-02 00:00:00 | 2013-05-03 00:00:00 | 2013-05-04 00:00:00 | 2013-05-05 00:00:00 | 2013-05-06 00:00:00 | 2013-05-07 00:00:00 | 2013-05-08 00:00:00 | 2013-05-09 00:00:00 | 2013-05-10 00:00:00 | 2013-05-11 00:00:00 | 2013-05-12 00:00:00 | 2013-05-13 00:00:00 | 2013-05-14 00:00:00 | 2013-05-15 00:00:00 | 2013-05-16 00:00:00 | 2013-05-17 00:00:00 | 2013-05-18 00:00:00 | 2013-05-19 00:00:00 | 2013-05-20 00:00:00 | 2013-05-21 00:00:00 | 2013-05-22 00:00:00 | 2013-05-23 00:00:00 | 2013-05-24 00:00:00 | 2013-05-25 00:00:00 | 2013-05-26 00:00:00 | 2013-05-27 00:00:00 | 2013-05-28 00:00:00 | 2013-05-29 00:00:00 | 2013-05-30 00:00:00 | 2013-05-31 00:00:00 | 2013-06-01 00:00:00 | 2013-06-02 00:00:00 | 2013-06-03 00:00:00 | 2013-06-04 00:00:00 | 2013-06-05 00:00:00 | 2013-06-06 00:00:00 | 2013-06-07 00:00:00 | 2013-06-08 00:00:00 | 2013-06-09 00:00:00 | 2013-06-10 00:00:00 | 2013-06-11 00:00:00 | 2013-06-12 00:00:00 | 2013-06-13 00:00:00 | 2013-06-14 00:00:00 | 2013-06-15 00:00:00 | 2013-06-16 00:00:00 | 2013-06-17 00:00:00 | 2013-06-18 00:00:00 | 2013-06-19 00:00:00 | 2013-06-20 00:00:00 | 2013-06-21 00:00:00 | 2013-06-22 00:00:00 | 2013-06-23 00:00:00 | 2013-06-24 00:00:00 | 2013-06-25 00:00:00 | 2013-06-26 00:00:00 | 2013-06-27 00:00:00 | 2013-06-28 00:00:00 | 2013-06-29 00:00:00 | 2013-06-30 00:00:00
 |  |  |  |  | Input Here |  |  | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun
1 | 10052 | Waleed [NAME] | Section Head Matls | Material Handling | 2012-09-01 00:00:00 | 2012-09-05 00:00:00 | SL | 41153 | 41154 | 41155 | 41156 | 41157 | 41158 | 41159 | 41160 | 41161 | 41162 | 41163 | 41164 | 41165 | 41166 | 41167 | 41168 | 41169 | 41170 | 41171 | 41172 | 41173 | 41174 | 41175 | 41176 | 41177 | 41178 | 41179 | 41180 | 41181 | 41182 | 41183 | 41184 | 41185 | 41186 | 41187 | 41188 | 41189 | 41190 | 41191 | 41192 | 41193 | 41194 | 41195 | 41196 | 41197 | 41198 | 41199 | 41200 | 41201 | 41202 | 41203 | 41204 | 41205 | 41206 | 41207 | 41208 | 41209 | 41210 | 41211 | 41212 | 41213 | 41214 | 41215 | 41216 | 41217 | 41218 | 41219 | 41220 | 41221 | 41222 | 41223 | 41224 | 41225 | 41226 | 41227 | 41228 | 41229 | 41230 | 41231 | 41232 | 41233 | 41234 | 41235 | 41236 | 41237 | 41238 | 41239 | 41240 | 41241 | 41242 | 41243 | 41244 | 41245 | 41246 | 41247 | 41248 | 41249 | 41250 | 41251 | 41252 | 41253 | 41254 | 41255 | 41256 | 41257 | 41258 | 41259 | 41260 | 41261 | 41262 | 41263 | 41264 | 41265 | 41266 | 41267 | 41268 | 41269 | 41270 | 41271 | 41272 | 41273 | 41274 | 41275 | 41276 | 41277 | 41278 | 41279 | 41280 | 41281 | 41282 | 41283 | 41284 | 41285 | 41286 | 41287 | 41288 | 41289 | 41290 | 41291 | 41292 | 41293 | 41294 | 41295 | 41296 | 41297 | 41298 | 41299 | 41300 | 41301 | 41302 | 41303 | 41304 | 41305 | 41306 | 41307 | 41308 | 41309 | 41310 | 41311 | 41312 | 41313 | 41314 | 41315 | 41316 | 41317 | 41318 | 41319 | 41320 | 41321 | 41322 | 41323 | 41324 | 41325 | 41326 | 41327 | 41328 | 41329 | 41330 | 41331 | 41332 | 41333 | 41334 | 41335 | 41336 | 41337 | 41338 | 41339 | 41340 | 41341 | 41342 | 41343 | 41344 | 41345 | 41346 | 41347 | 41348 | 41349 | 41350 | 41351 | 41352 | 41353 | 41354 | 41355 | 41356 | 41357 | 41358 | 41359 | 41360 | 41361 | 41362 | 41363 | 41364 | 41365 | 41366 | 41367 | 41368 | 41369 | 41370 | 41371 | 41372 | 41373 | 41374 | 41375 | 41376 | 41377 | 41378 | 41379 | 41380 | 41381 | 41382 | 41383 | 41384 | 41385 | 41386 | 41387 | 41388 | 41389 | 41390 | 41391 | 41392 | 41393 | 41394 | 41395 | 41396 | 41397 | 41398 | 41399 | 41400 | 41401 | 41402 | 41403 | 41404 | 41405 | 41406 | 41407 | 41408 | 41409 | 41410 | 41411 | 41412 | 41413 | 41414 | 41415 | 41416 | 41417 | 41418 | 41419 | 41420 | 41421 | 41422 | 41423 | 41424 | 41425 | 41426 | 41427 | 41428 | 41429 | 41430 | 41431 | 41432 | 41433 | 41434 | 41435 | 41436 | 41437 | 41438 | 41439 | 41440 | 41441 | 41442 | 41443 | 41444 | 41445 | 41446 | 41447 | 41448 | 41449 | 41450 | 41451 | 41452 | 41453 | 41454 | 41455