Spreadsheet: 161926d1339674286-count-if-formula-based-of-conditional-formatting-example
Sheet: Example dept (4)

 | Certificate Valid for |  | 24 | 12 | 12 | 12 | 12 | 36 | 18 | 12 | 12 | 12
 | Staff Name | Position | Course 1 | Course 2 | Course 3 | Course 4 | Course 5 | Course 6 | Course 7 | Course 8 | Course 10 | Course 11
 | Colleague 1 | SM | 2005-03-24 00:00:00 | 2012-05-31 00:00:00 |  | CHECK | 2005-05-26 00:00:00 | 2009-04-28 00:00:00 | 2009-04-30 00:00:00 | 2010-10-19 00:00:00 | 2010-01-04 00:00:00 | 2012-05-31 00:00:00
 | Colleague 2 | Support Staff |  | 2012-05-31 00:00:00 |  |  |  | 2010-06-22 00:00:00 |  |  | 2009-05-27 00:00:00 | 2012-05-31 00:00:00
 | Colleague 3 | DSM | 2010-10-26 00:00:00 | 2012-05-31 00:00:00 |  | 2010-10-19 00:00:00 | 2011-10-03 00:00:00 | 2007-08-31 00:00:00 | 2010-11-11 00:00:00 |  | 2009-12-08 00:00:00 | 2012-05-31 00:00:00
 | Colleague 4 | Relief Staff | 2007-11-07 00:00:00 |  |  | 2011-01-10 00:00:00 | 2010-11-19 00:00:00 | 2011-11-07 00:00:00 | 2010-09-23 00:00:00 |  | 2008-10-20 00:00:00
 | Colleague 5 | Support Staff | 2010-08-25 00:00:00 | 2012-05-31 00:00:00 |  | 2011-06-13 00:00:00 | 2011-10-03 00:00:00 | 2011-11-07 00:00:00 | 2012-04-08 00:00:00 |  | 2009-05-27 00:00:00 | 2012-05-31 00:00:00
 | Colleague 6 | Support Staff |  | 2012-05-31 00:00:00 |  | 2011-06-13 00:00:00 | 2011-06-03 00:00:00 | 2011-01-24 00:00:00 | 2012-04-08 00:00:00 |  | 2011-02-11 00:00:00 | 2012-05-31 00:00:00
 | Colleague 7 | Support Staff | 2011-08-13 00:00:00 | 2012-05-31 00:00:00 |  | 2011-03-15 00:00:00 | 2011-02-24 00:00:00 |  | 2005-09-06 00:00:00 |  | 2010-05-21 00:00:00 | 2012-05-31 00:00:00
 | Colleague 8 | DSM | 2011-12-15 00:00:00 |  |  | 2010-10-11 00:00:00 |  |  | 2011-10-27 00:00:00 | 2010-10-21 00:00:00 | 2009-04-01 00:00:00
 | Colleague 9 | Relief Staff | 2011-05-16 00:00:00 | 2012-05-31 00:00:00 |  | 2011-11-21 00:00:00 | 2011-10-11 00:00:00 | 2011-11-07 00:00:00 | 2011-10-27 00:00:00 | 2010-10-21 00:00:00 | 2009-12-08 00:00:00 | 2012-05-31 00:00:00
 | Colleague 10 | Support Staff | 2012-01-31 00:00:00 |  |  | 2011-03-30 00:00:00 | 2011-12-13 00:00:00 |  | 2011-08-03 00:00:00 | 2009-04-23 00:00:00 | 2010-01-04 00:00:00
 | Colleague 11 | Support Staff |  | 2012-05-31 00:00:00 |  | 2010-11-08 00:00:00 | 2011-06-03 00:00:00 |  | 2012-05-03 00:00:00 | 2010-10-25 00:00:00 |  | 2012-05-31 00:00:00
 | Colleague 12 | DSM | 2011-07-18 00:00:00 |  |  |  | 2011-06-03 00:00:00 |  | 2011-06-09 00:00:00 | 2011-06-13 00:00:00 | 2011-06-27 00:00:00
 | Colleague 13 | Relief Staff |  | 2012-05-31 00:00:00 |  |  | 2011-02-08 00:00:00 |  |  |  | 2010-05-21 00:00:00 | 2012-05-31 00:00:00
 | Colleague 14 | Support Staff |  | 2012-05-31 00:00:00 |  | 2010-10-13 00:00:00 | 2011-10-03 00:00:00 | 2010-06-22 00:00:00 | 2010-11-24 00:00:00 |  | 2010-06-09 00:00:00 | 2012-05-31 00:00:00
 | Colleague 15 | Support Staff | 2011-05-29 00:00:00 |  |  | 2011-11-30 00:00:00 | 2010-09-06 00:00:00 | 2010-11-09 00:00:00 | 2010-11-19 00:00:00
 | Colleague 16 | DSM | 2010-10-26 00:00:00 | 2012-05-31 00:00:00 |  | 2011-03-01 00:00:00 | 2011-09-23 00:00:00 | 2010-01-19 00:00:00 | 2010-10-27 00:00:00 | 2010-10-25 00:00:00 | 2011-02-10 00:00:00 | 2012-05-31 00:00:00
 | Colleague 17 | Relief Staff | 2010-10-09 00:00:00 | 2012-05-31 00:00:00 |  |  |  |  | 2012-05-03 00:00:00 | CHECK | 2012-02-28 00:00:00 | 2012-05-31 00:00:00
 | Colleague 18 | Support Staff | CHECK | 2012-05-31 00:00:00 |  |  |  | 2007-03-30 00:00:00 |  |  | 2008-06-02 00:00:00 | 2012-05-31 00:00:00
 | Colleague 19 | Support Staff |  | 2012-05-31 00:00:00 |  |  |  | 2007-02-21 00:00:00 |  |  |  | 2012-05-31 00:00:00
 | Colleague 20 | Support Staff |  | 2012-05-31 00:00:00 |  |  |  |  |  |  |  | 2012-05-31 00:00:00
 | Colleague 21 | Support Staff |  | NOT REQUIRED |  | 2011-12-13 00:00:00 | 2011-10-07 00:00:00 | 2011-01-14 00:00:00 | 2010-11-24 00:00:00 | 2009-11-19 00:00:00 | 2011-09-12 00:00:00