Spreadsheet: 106474d1303758404-count-conditional-formated-cells-sample
Sheet: sample

Tracking | [NAME] 1 |  |  | Milestone 2 |  |  | Milestone 3
 | PLAN 1 | FCST 1 | ACT 1 | PLAN 2 | FCST 2 | ACT 2 | PLAN 3 | FCST 3 | ACT3
3775000239 | 2010-08-01 00:00:00 | 2010-09-24 00:00:00 | 2010-09-24 00:00:00 | 2010-08-29 00:00:00 | 2010-11-08 00:00:00 | 2010-11-08 00:00:00 | 2010-09-28 00:00:00 | 2010-11-08 00:00:00 | 2010-11-08 00:00:00
3775000240 | 2009-05-26 00:00:00 | 2009-05-26 00:00:00 | 2009-05-26 00:00:00 | 2009-06-30 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2009-07-30 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00
3775000241 | 2009-05-19 00:00:00 | 2009-05-19 00:00:00 | 2009-05-19 00:00:00 | 2009-06-30 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2009-07-30 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00
3775000242 | 2009-06-22 00:00:00 | 2009-06-22 00:00:00 | 2009-06-22 00:00:00 | 2009-07-20 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2009-08-19 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00
3775000243 | 2009-03-23 00:00:00 | 2009-03-23 00:00:00 | 2009-03-23 00:00:00 | 2009-06-30 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2009-07-30 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00
3775000244 | 2009-03-31 00:00:00 | 2009-03-31 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2009-07-30 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00
3775000245 | 2009-03-17 00:00:00 | 2009-03-17 00:00:00 | 2009-03-17 00:00:00 | 2009-06-30 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2009-07-30 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00
3775000246 | 2009-03-26 00:00:00 | 2009-03-26 00:00:00 | 2009-03-26 00:00:00 | 2009-06-30 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2009-07-30 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00
3775000247 | 2010-05-20 00:00:00 | 2010-12-27 00:00:00 | 2010-12-27 00:00:00 | 2010-06-27 00:00:00 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00 | 2010-07-27 00:00:00 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00
3775000248 | 2009-07-15 00:00:00 | 2009-07-31 00:00:00 | 2009-07-31 00:00:00 | 2009-07-27 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2009-08-26 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00
3775000250 | 2011-02-24 00:00:00 | 2011-03-31 00:00:00 | 2011-03-31 00:00:00 | 2011-02-28 00:00:00 | 2011-05-23 00:00:00 |  | 2011-03-30 00:00:00 | 2011-06-22 00:00:00
3775000251 | 2009-10-31 00:00:00 | 2009-11-30 00:00:00 | 2009-11-30 00:00:00 | 2009-11-16 00:00:00 | 2010-02-15 00:00:00 | 2010-02-15 00:00:00 | 2009-12-16 00:00:00 | 2010-06-30 00:00:00 | 2010-06-30 00:00:00
3775000252 | 2009-07-31 00:00:00 | 2009-07-31 00:00:00 | 2009-07-31 00:00:00 | 2009-09-15 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2009-10-15 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00
3775000253 | 2011-09-15 00:00:00 | 2011-09-22 00:00:00 |  | 2011-10-23 00:00:00 | 2011-12-23 00:00:00 |  | 2011-11-22 00:00:00 | 2012-01-22 00:00:00
3775000254 | 2011-09-23 00:00:00 | 2011-09-23 00:00:00 |  | 2011-10-23 00:00:00 | 2011-11-23 00:00:00 |  | 2011-11-22 00:00:00 | 2011-12-23 00:00:00
3775000255 | 2009-08-30 00:00:00 | 2009-08-28 00:00:00 | 2009-08-28 00:00:00 | 2009-10-30 00:00:00 | 2010-03-05 00:00:00 | 2010-03-05 00:00:00 | 2009-11-29 00:00:00 | 2010-06-17 00:00:00 | 2010-06-17 00:00:00
3775000256 | 2011-09-23 00:00:00 | 2011-09-23 00:00:00 |  | 2012-02-15 00:00:00 | 2012-02-15 00:00:00 |  | 2012-03-16 00:00:00 | 2012-03-16 00:00:00
3775000257 | 2010-01-27 00:00:00 | 2010-01-27 00:00:00 | 2010-01-27 00:00:00 | 2010-03-15 00:00:00 | 2010-03-05 00:00:00 | 2010-03-05 00:00:00 | 2010-04-14 00:00:00 | 2010-06-30 00:00:00 | 2010-06-30 00:00:00
3775000258 | 2010-10-01 00:00:00 | 2010-11-30 00:00:00 | 2010-11-30 00:00:00 | 2010-06-05 00:00:00 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00 | 2010-07-05 00:00:00 | 2011-05-15 00:00:00 | 2010-12-10 00:00:00
3775000259 | 2010-04-05 00:00:00 | 2010-05-27 00:00:00 | 2010-05-27 00:00:00 | 2010-03-26 00:00:00 | 2010-06-30 00:00:00 | 2010-06-30 00:00:00 | 2010-04-25 00:00:00 | 2010-08-19 00:00:00 | 2010-08-19 00:00:00
3775000260 | 2010-02-26 00:00:00 | 2010-02-26 00:00:00 | 2010-02-26 00:00:00 | 2010-03-05 00:00:00 | 2010-03-03 00:00:00 | 2010-03-03 00:00:00 | 2010-03-28 00:00:00 | 2010-06-30 00:00:00 | 2010-06-30 00:00:00
3775000261 | 2010-01-28 00:00:00 | 2010-01-28 00:00:00 | 2010-01-28 00:00:00 | 2010-02-01 00:00:00 | 2010-02-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-28 00:00:00 | 2010-05-18 00:00:00 | 2010-05-18 00:00:00
3775000262 | 2009-02-26 00:00:00 | 2009-02-26 00:00:00 | 2009-02-26 00:00:00 | 2009-06-10 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2009-07-10 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00
3775000263 | 2009-09-30 00:00:00 | 2009-10-13 00:00:00 | 2009-10-13 00:00:00 | 2009-09-13 00:00:00 | 2010-02-15 00:00:00 | 2010-02-15 00:00:00 | 2009-10-13 00:00:00 | 2010-06-17 00:00:00 | 2010-06-17 00:00:00
3775000264 | 2010-07-30 00:00:00 | 2010-11-30 00:00:00 | 2010-11-30 00:00:00 | 2010-06-22 00:00:00 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00 | 2010-07-22 00:00:00 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00
3775000265 | 2010-08-01 00:00:00 | 2010-10-29 00:00:00 | 2010-10-29 00:00:00 | 2010-09-01 00:00:00 | 2010-11-15 00:00:00 | 2010-11-15 00:00:00 | 2010-10-01 00:00:00 | 2010-11-15 00:00:00 | 2010-11-15 00:00:00
3775000266 | 2010-07-10 00:00:00 | 2010-10-08 00:00:00 | 2010-10-08 00:00:00 | 2010-07-30 00:00:00 | 2010-11-15 00:00:00 | 2010-11-15 00:00:00 | 2010-08-29 00:00:00 | 2010-11-15 00:00:00 | 2010-11-15 00:00:00
3775000268 | 2010-04-06 00:00:00 | 2010-03-15 00:00:00 | 2010-03-15 00:00:00 | 2010-03-15 00:00:00 | 2010-03-12 00:00:00 | 2010-03-12 00:00:00 | 2010-03-28 00:00:00 | 2010-05-18 00:00:00 | 2010-05-18 00:00:00
3775000269 | 2012-08-24 00:00:00 | 2012-08-24 00:00:00 |  | 2012-12-31 00:00:00 | 2012-12-31 00:00:00 |  | 2012-12-31 00:00:00 | 2013-01-30 00:00:00
3775000270 | 2009-02-27 00:00:00 | 2009-02-27 00:00:00 | 2009-02-27 00:00:00 | 2009-06-10 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2009-07-10 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00
3775000272 | 2012-09-23 00:00:00 | 2012-09-23 00:00:00 |  | 2012-10-23 00:00:00 | 2012-10-23 00:00:00 |  | 2012-10-23 00:00:00 | 2012-11-22 00:00:00
3775000273 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 2009-07-22 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2009-08-21 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00
3775000274 | 2010-08-15 00:00:00 | 2010-09-27 00:00:00 | 2010-09-27 00:00:00 | 2010-09-30 00:00:00 | 2010-11-15 00:00:00 | 2010-11-15 00:00:00 | 2010-10-30 00:00:00 | 2010-11-11 00:00:00 | 2010-11-11 00:00:00
3775000280 | 2009-12-31 00:00:00 | 2009-12-03 00:00:00 | 2009-12-03 00:00:00 | 2010-11-09 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-09 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00
3775000286 | 2010-05-10 00:00:00 | 2010-09-27 00:00:00 | 2010-09-27 00:00:00 | 2010-04-15 00:00:00 | 2010-11-15 00:00:00 | 2010-11-15 00:00:00 | 2010-05-15 00:00:00 | 2010-11-11 00:00:00 | 2010-11-11 00:00:00
3775000287 | 2009-07-30 00:00:00 | 2009-07-15 00:00:00 | 2009-07-15 00:00:00 | 2009-08-13 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2009-09-12 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00
3775000288 | 2011-06-30 00:00:00 | 2011-02-24 00:00:00 | 2011-02-24 00:00:00 | 2011-03-31 00:00:00 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00 | 2011-04-30 00:00:00 | 2011-05-30 00:00:00
3775000289 | 2009-09-14 00:00:00 | 2009-09-14 00:00:00 | 2009-09-14 00:00:00 | 2009-11-30 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2009-12-30 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00
3775000290 | 2009-07-30 00:00:00 | 2009-07-17 00:00:00 | 2009-07-17 00:00:00 | 2009-08-16 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2009-09-15 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00
3775000308 | 2010-10-15 00:00:00 | 2010-12-30 00:00:00 | 2010-12-30 00:00:00 | 2010-07-30 00:00:00 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00 | 2010-08-29 00:00:00 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00
3775000311 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-11-09 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2009-12-09 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00
3775000420 | 2011-06-19 00:00:00 | 2010-12-30 00:00:00 | 2010-12-30 00:00:00 | 2011-07-07 00:00:00 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00 | 2011-08-06 00:00:00 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00
3775000421 | 2011-07-04 00:00:00 | 2011-03-31 00:00:00 | 2011-03-31 00:00:00 | 2011-09-25 00:00:00 | 2011-05-25 00:00:00 |  | 2011-10-25 00:00:00 | 2011-06-24 00:00:00
3775000422 | 2010-11-15 00:00:00 | 2010-10-26 00:00:00 | 2010-10-26 00:00:00 | 2011-01-04 00:00:00 | 2010-11-15 00:00:00 | 2010-11-15 00:00:00 | 2011-02-03 00:00:00 | 2010-11-15 00:00:00 | 2010-11-15 00:00:00
3775000423 | 2011-02-15 00:00:00 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | 2011-03-30 00:00:00 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00 | 2011-04-29 00:00:00 | 2011-05-21 00:00:00
3775000424 | 2011-02-24 00:00:00 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | 2011-03-30 00:00:00 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00 | 2011-04-29 00:00:00 | 2011-05-29 00:00:00
3775000425 | 2010-10-20 00:00:00 | 2010-12-30 00:00:00 | 2010-12-30 00:00:00 | 2011-01-04 00:00:00 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00 | 2011-02-03 00:00:00 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00
3775000426 | 2010-10-18 00:00:00 | 2010-12-30 00:00:00 | 2010-12-30 00:00:00 | 2011-01-04 00:00:00 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00 | 2011-02-03 00:00:00 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00
3775000427 | 2010-11-05 00:00:00 | 2010-09-30 00:00:00 | 2010-09-30 00:00:00 | 2011-01-04 00:00:00 | 2010-11-15 00:00:00 | 2010-11-15 00:00:00 | 2011-02-03 00:00:00 | 2010-11-11 00:00:00 | 2010-11-11 00:00:00
3775000428 | 2010-11-18 00:00:00 | 2010-06-24 00:00:00 | 2010-06-24 00:00:00 | 2011-01-04 00:00:00 | 2010-11-15 00:00:00 | 2010-11-15 00:00:00 | 2011-02-03 00:00:00 | 2010-11-11 00:00:00 | 2010-11-11 00:00:00
3775000429 | 2010-11-05 00:00:00 | 2010-12-30 00:00:00 | 2010-12-30 00:00:00 | 2011-01-04 00:00:00 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00 | 2011-02-03 00:00:00 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00
3775000430 | 2011-06-12 00:00:00 | 2011-06-12 00:00:00 |  | 2011-07-30 00:00:00 | 2011-07-30 00:00:00 |  | 2011-08-29 00:00:00 | 2011-08-29 00:00:00
3775000431 | 2010-12-01 00:00:00 | 2010-11-30 00:00:00 | 2010-11-30 00:00:00 | 2011-01-04 00:00:00 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00 | 2011-02-03 00:00:00 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00
3775000432 | 2010-11-15 00:00:00 | 2010-10-08 00:00:00 | 2010-10-08 00:00:00 | 2011-01-04 00:00:00 | 2010-11-15 00:00:00 | 2010-11-15 00:00:00 | 2011-02-03 00:00:00 | 2010-11-15 00:00:00 | 2010-11-15 00:00:00
1111000230 | 2010-04-15 00:00:00 | 2010-04-30 00:00:00 | 2010-04-30 00:00:00 | 2010-08-02 00:00:00 | 2010-05-18 00:00:00 | 2010-05-18 00:00:00 | 2010-09-02 00:00:00 | 2010-05-18 00:00:00 | 2010-05-18 00:00:00
1111000231 | 2010-10-31 00:00:00 | 2010-10-31 00:00:00 |  | 2010-11-01 00:00:00 | 2010-12-16 00:00:00 |  | 2011-01-15 00:00:00 | 2011-01-15 00:00:00
1111000232 | 2010-11-01 00:00:00 | 2010-11-01 00:00:00 | 2010-11-01 00:00:00 | 2011-11-13 00:00:00 | 2010-09-27 00:00:00 | 2010-09-27 00:00:00 | 2010-10-27 00:00:00 | 2010-10-27 00:00:00
1111000233 | 2012-11-12 00:00:00 | 2012-11-12 00:00:00 |  | 2011-08-30 00:00:00 | 2011-08-30 00:00:00 |  | 2011-12-16 00:00:00 | 2011-09-29 00:00:00