Spreadsheet: 167930d1342160724-excel-2007-need-help-to-be-able-to-change-colors-of-a-cell-based-upon-the-date-in-the-cell-cf-1st-platoon-mandatory-training-tracker
Sheet: Annual Certifications

RANK | NAME | ACCIDENT                   AVOIDANCE | ANTI-TERRORISM LEVEL 1 | COMBATTING TRAFFICKING IN PERSONS | GLOBAL ASSEMENT TOOL | INFORMATION ASSURANCE | LAW OF WAR | ISOPREP / PRO-File | SHARP | OPERATIONAL SECURITY | INFORMATION SECURITY | SUICIDE AWARENESS | MTBI / PTSD | FRATERN               -IZATION
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 |  | 2012-06-22 00:00:00 | 2012-06-22 00:00:00 | 2012-07-12 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 |  | 2012-01-01 00:00:00 |  | 2011-12-05 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 |  | 2011-11-08 00:00:00 |  | 2011-07-12 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2011-07-18 00:00:00 | 2013-02-10 00:00:00 | 2012-02-01 00:00:00 |  | 2012-03-13 00:00:00 | 2012-07-09 00:00:00 |  | Look at conditional formatting Rules.
PVT | Snuffy, [NAME] | 2012-01-25 00:00:00 | 2012-01-25 00:00:00 | 2012-06-20 00:00:00 | 2012-06-20 00:00:00 | 2012-06-22 00:00:00 | 2011-08-10 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 | 2012-03-15 00:00:00 | 2012-01-10 00:00:00 |  | 2012-04-16 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 |  | 2012-06-20 00:00:00 | 2012-06-22 00:00:00 | 2012-07-12 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 |  |  |  | 2012-02-29 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2011-08-17 00:00:00 | 2012-03-11 00:00:00 | 2012-06-20 00:00:00 | 2012-06-20 00:00:00 | 2012-03-09 00:00:00 | 2011-12-09 00:00:00
PVT | Snuffy, [NAME] | 2012-03-22 00:00:00 |  | 2012-06-22 00:00:00 | 2012-06-22 00:00:00 | 2012-07-12 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 | 2012-01-10 00:00:00 | 2011-12-19 00:00:00 |  | 2012-07-12 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-06-22 00:00:00 | 2012-06-23 00:00:00 | 2012-06-22 00:00:00 | 2012-06-20 00:00:00 | 2012-06-22 00:00:00 | 2012-01-25 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 | 2011-12-07 00:00:00 | 2012-02-16 00:00:00 |  | 2012-07-12 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-06-25 00:00:00 | 2012-06-25 00:00:00 | 2011-09-06 00:00:00 | 2012-04-05 00:00:00 | 2012-03-09 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 |  | 2012-06-22 00:00:00 | 2012-03-22 00:00:00 | 2012-07-12 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 | 2012-02-14 00:00:00 | 2012-02-21 00:00:00 |  | 2010-11-10 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 | 2012-06-24 00:00:00 | 2012-06-20 00:00:00 | 2012-06-20 00:00:00 | 2012-07-12 00:00:00 | 2010-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-03-14 00:00:00 | 2012-02-15 00:00:00 | 2012-02-15 00:00:00 |  | 2012-04-14 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-01-31 00:00:00 | 2012-03-22 00:00:00 | 2012-06-20 00:00:00 | 2012-03-22 00:00:00 | 2012-06-22 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 | 2012-02-14 00:00:00 |  |  | 2012-02-14 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 | 2012-02-02 00:00:00 | 2012-06-20 00:00:00 | 2012-06-20 00:00:00 | 2012-06-22 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2011-12-28 00:00:00 |  | 2012-02-15 00:00:00 |  | 2011-12-05 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 | 2012-04-05 00:00:00 | 2012-07-12 00:00:00 |  | 2011-10-20 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-01-04 00:00:00 |  | 2011-12-26 00:00:00 |  | 2011-11-13 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME]
PVT | Snuffy, [NAME] | 2012-03-20 00:00:00 |  | 2012-06-20 00:00:00 | 2012-06-20 00:00:00 | 2012-07-12 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-03-20 00:00:00 | 2012-03-22 00:00:00 | 2012-06-20 00:00:00 | 2012-06-20 00:00:00 | 2012-07-12 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 | 2012-03-20 00:00:00 | 2012-06-20 00:00:00 | 2012-01-31 00:00:00 | 2012-07-12 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2011-10-18 00:00:00 | 2012-06-24 00:00:00 | 2012-06-20 00:00:00 | 2012-06-20 00:00:00 | 2011-10-18 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 | 2011-07-09 00:00:00 | 2012-06-22 00:00:00 | 2012-03-25 00:00:00 | 2012-06-22 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 |  | 2012-06-22 00:00:00 | 2012-03-18 00:00:00 | 2012-06-22 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 | 2012-02-14 00:00:00 | 2011-10-15 00:00:00 |  | 2012-07-12 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2011-11-15 00:00:00 | 2012-07-12 00:00:00 | 2012-06-20 00:00:00 | 2011-11-15 00:00:00 | 2012-07-12 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-01-30 00:00:00 | 2012-01-30 00:00:00 | 2012-01-30 00:00:00 | 2012-06-20 00:00:00 | 2011-03-30 00:00:00 | 2012-01-30 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 |  | 2012-01-31 00:00:00 | 2012-06-20 00:00:00 | 2012-06-26 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 | 2012-02-13 00:00:00 | 2012-07-12 00:00:00 |  | 2012-01-02 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2011-11-08 00:00:00 | 2011-09-09 00:00:00 | 2012-06-20 00:00:00 | 2012-06-20 00:00:00 | 2011-12-15 00:00:00 | 2011-11-28 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 | 2012-03-09 00:00:00 |  |  | 2011-09-12 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-01-16 00:00:00 | 2012-03-16 00:00:00 | 2012-01-10 00:00:00 |  | 2012-01-16 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 | 2012-01-31 00:00:00 | 2012-06-20 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 | 2012-06-26 00:00:00 | 2012-06-20 00:00:00 | 2012-04-29 00:00:00 | 2012-06-26 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 |  | 2012-07-12 00:00:00 |  | 2012-07-12 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 |  | 2012-06-20 00:00:00 | 2012-06-20 00:00:00 | 2012-07-12 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-02-01 00:00:00 | 2012-01-31 00:00:00 | 2012-06-20 00:00:00 | 2012-06-20 00:00:00 | 2012-06-26 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 |  | 2012-06-20 00:00:00 | 2012-06-20 00:00:00 | 2012-06-22 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 | 2012-03-16 00:00:00 | 2012-06-20 00:00:00 | 2012-06-20 00:00:00 | 2012-03-20 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 |  | 2012-07-12 00:00:00 |  |  | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 |  | 2012-06-20 00:00:00 | 2012-06-20 00:00:00 | 2012-07-12 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2011-08-19 00:00:00 |  | 2012-06-20 00:00:00 | 2012-06-20 00:00:00 | 2012-07-12 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2011-09-13 00:00:00 | 2011-10-24 00:00:00 | 2011-09-13 00:00:00 | 2012-04-30 00:00:00 | 2012-03-22 00:00:00 | 2012-07-09 00:00:00
PVT | Snuffy, [NAME] | 2012-07-12 00:00:00 |  | 2012-07-12 00:00:00 |  | 2012-07-12 00:00:00 | 2012-07-09 00:00:00