Spreadsheet: 216507d1361795115-conditional-formatting-student-traffic-light-system_etaf
Sheet: Civil PGRs

2011-01-01 00:00:00 | 2013-09-01 00:00:00 | 2012-02-01 00:00:00 | 2013-10-01 00:00:00 |  |  | 2012-02-01 00:00:00 | 2013-10-01 00:00:00
2011-12-01 00:00:00 | 2014-10-01 00:00:00 | 2013-01-01 00:00:00 | 2014-09-01 00:00:00 |  |  | 2013-01-01 00:00:00 | 2014-09-01 00:00:00
2010-01-01 00:00:00 | 2014-12-01 00:00:00 | 2011-02-01 00:00:00 | 2012-10-01 00:00:00 |  |  | 2011-02-01 00:00:00 | 2012-10-01 00:00:00
2012-07-02 00:00:00 | 2015-01-02 00:00:00 | 2013-08-02 00:00:00 | 2015-04-02 00:00:00 |  |  | 2013-08-02 00:00:00 | 2015-04-02 00:00:00
2006-01-01 00:00:00 | 2012-12-31 00:00:00 | 2007-02-01 00:00:00 | 2008-10-01 00:00:00 |  |  | 2007-02-01 00:00:00 | 2008-10-01 00:00:00
2006-04-01 00:00:00 | 2012-08-20 00:00:00 | 2007-05-01 00:00:00 | 2009-01-01 00:00:00 |  |  | 2007-05-01 00:00:00 | 2009-01-01 00:00:00
2012-09-25 00:00:00 | 2015-09-25 00:00:00 | 2013-10-25 00:00:00 | 2015-06-25 00:00:00 |  |  | 2013-10-25 00:00:00 | 2015-06-25 00:00:00
2007-07-01 00:00:00 | 2012-06-30 00:00:00 | 2008-08-01 00:00:00 | 2010-04-01 00:00:00 |  |  | 2008-08-01 00:00:00 | 2010-04-01 00:00:00
2008-10-06 00:00:00 | 2013-04-01 00:00:00 | 2009-11-06 00:00:00 | 2011-07-06 00:00:00 |  |  | 2009-11-06 00:00:00 | 2011-07-06 00:00:00
2004-04-01 00:00:00 | 2011-12-31 00:00:00 | 2005-05-01 00:00:00 | 2007-01-01 00:00:00 |  |  | 2005-05-01 00:00:00 | 2007-01-01 00:00:00
2010-01-01 00:00:00 | 2014-01-01 00:00:00 | 2011-02-01 00:00:00 | 2012-10-01 00:00:00 |  |  | 2011-02-01 00:00:00 | 2012-10-01 00:00:00
2011-01-01 00:00:00 | 2015-01-01 00:00:00 | 2012-02-01 00:00:00 | 2013-10-01 00:00:00 |  |  | 2012-02-01 00:00:00 | 2013-10-01 00:00:00
2011-07-01 00:00:00 | 2017-07-01 00:00:00 | 2012-08-01 00:00:00 | 2014-04-01 00:00:00 |  |  | 2012-08-01 00:00:00 | 2014-04-01 00:00:00
2012-04-02 00:00:00 | 2016-04-01 00:00:00 | 2013-05-02 00:00:00 | 2015-01-02 00:00:00 |  |  | 2013-05-02 00:00:00 | 2015-01-02 00:00:00
2004-04-01 00:00:00 | 2012-11-02 00:00:00 | 2005-05-01 00:00:00 | 2007-01-01 00:00:00 |  |  | 2005-05-01 00:00:00 | 2007-01-01 00:00:00
2006-10-01 00:00:00 | 2014-09-01 00:00:00 | 2007-11-01 00:00:00 | 2009-07-01 00:00:00 |  |  | 2007-11-01 00:00:00 | 2009-07-01 00:00:00
2012-10-01 00:00:00 | 2015-10-01 00:00:00 | 2013-11-01 00:00:00 | 2015-07-01 00:00:00 |  |  | 2013-11-01 00:00:00 | 2015-07-01 00:00:00
2009-10-01 00:00:00 | 2014-01-01 00:00:00 | 2010-11-01 00:00:00 | 2012-07-01 00:00:00 |  |  | 2010-11-01 00:00:00 | 2012-07-01 00:00:00
2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2012-02-01 00:00:00 | 2013-10-01 00:00:00 |  |  | 2012-02-01 00:00:00 | 2013-10-01 00:00:00
2008-07-01 00:00:00 | 2016-07-01 00:00:00 | 2009-08-01 00:00:00 | 2011-04-01 00:00:00 |  |  | 2009-08-01 00:00:00 | 2011-04-01 00:00:00
2010-08-01 00:00:00 | 2013-07-01 00:00:00 | 2011-09-01 00:00:00 | 2013-05-01 00:00:00 |  |  | 2011-09-01 00:00:00 | 2013-05-01 00:00:00
2008-03-01 00:00:00 | 2013-01-31 00:00:00 | 2009-04-01 00:00:00 | 2010-12-01 00:00:00 |  |  | 2009-04-01 00:00:00 | 2010-12-01 00:00:00
2006-10-01 00:00:00 | 2012-10-01 00:00:00 | 2007-11-01 00:00:00 | 2009-07-01 00:00:00 |  |  | 2007-11-01 00:00:00 | 2009-07-01 00:00:00
2010-01-26 00:00:00 | 2013-01-01 00:00:00 | 2011-02-26 00:00:00 | 2012-10-26 00:00:00 |  |  | 2011-02-26 00:00:00 | 2012-10-26 00:00:00
2011-11-01 00:00:00 | 2015-10-01 00:00:00 | 2012-12-01 00:00:00 | 2014-08-01 00:00:00 |  |  | 2012-12-01 00:00:00 | 2014-08-01 00:00:00
2011-01-01 00:00:00 | 2015-01-01 00:00:00 | 2012-02-01 00:00:00 | 2013-10-01 00:00:00 |  |  | 2012-02-01 00:00:00 | 2013-10-01 00:00:00
2011-10-03 00:00:00 | 2015-10-01 00:00:00 | 2012-11-03 00:00:00 | 2014-07-03 00:00:00 |  |  | 2012-11-03 00:00:00 | 2014-07-03 00:00:00
2001-04-01 00:00:00 | 2011-09-30 00:00:00 | 2002-05-01 00:00:00 | 2004-01-01 00:00:00 |  |  | 2002-05-01 00:00:00 | 2004-01-01 00:00:00
2007-04-01 00:00:00 | 2015-04-01 00:00:00 | 2008-05-01 00:00:00 | 2010-01-01 00:00:00 |  |  | 2008-05-01 00:00:00 | 2010-01-01 00:00:00
2008-04-01 00:00:00 | 2012-12-31 00:00:00 | 2009-05-01 00:00:00 | 2011-01-01 00:00:00 |  |  | 2009-05-01 00:00:00 | 2011-01-01 00:00:00
2011-10-03 00:00:00 | 2015-10-01 00:00:00 | 2012-11-03 00:00:00 | 2014-07-03 00:00:00 |  |  | 2012-11-03 00:00:00 | 2014-07-03 00:00:00
2009-01-01 00:00:00 | 2014-07-01 00:00:00 | 2010-02-01 00:00:00 | 2011-10-01 00:00:00 |  |  | 2010-02-01 00:00:00 | 2011-10-01 00:00:00
2012-07-24 00:00:00 | 2015-07-24 00:00:00 | 2013-08-24 00:00:00 | 2015-04-24 00:00:00 |  |  | 2013-08-24 00:00:00 | 2015-04-24 00:00:00
2011-07-01 00:00:00 | 2015-07-01 00:00:00 | 2012-08-01 00:00:00 | 2014-04-01 00:00:00 |  |  | 2012-08-01 00:00:00 | 2014-04-01 00:00:00
2009-10-28 00:00:00 | 2014-01-01 00:00:00 | 2010-11-28 00:00:00 | 2012-07-28 00:00:00 |  |  | 2010-11-28 00:00:00 | 2012-07-28 00:00:00
2011-04-01 00:00:00 | 2016-05-01 00:00:00 | 2012-05-01 00:00:00 | 2014-01-01 00:00:00 |  |  | 2012-05-01 00:00:00 | 2014-01-01 00:00:00
2012-07-09 00:00:00 | 2016-07-01 00:00:00 | 2013-08-09 00:00:00 | 2015-04-09 00:00:00 |  |  | 2013-08-09 00:00:00 | 2015-04-09 00:00:00
2011-09-26 00:00:00 | 2015-10-01 00:00:00 | 2012-10-26 00:00:00 | 2014-06-26 00:00:00 |  |  | 2012-10-26 00:00:00 | 2014-06-26 00:00:00
2006-01-01 00:00:00 | 2014-10-01 00:00:00 | 2007-02-01 00:00:00 | 2008-10-01 00:00:00 |  |  | 2007-02-01 00:00:00 | 2008-10-01 00:00:00
2008-01-12 00:00:00 | 2013-04-01 00:00:00 | 2009-02-12 00:00:00 | 2010-10-12 00:00:00 |  |  | 2009-02-12 00:00:00 | 2010-10-12 00:00:00
2008-01-01 00:00:00 | 2015-04-01 00:00:00 | 2009-02-01 00:00:00 | 2010-10-01 00:00:00 |  |  | 2009-02-01 00:00:00 | 2010-10-01 00:00:00
2012-09-29 00:00:00 | 2015-09-29 00:00:00 | 2013-10-29 00:00:00 | 2015-06-29 00:00:00 |  |  | 2013-10-29 00:00:00 | 2015-06-29 00:00:00
2011-04-04 00:00:00 | 2015-04-01 00:00:00 | 2012-05-04 00:00:00 | 2014-01-04 00:00:00 |  |  | 2012-05-04 00:00:00 | 2014-01-04 00:00:00
2008-04-01 00:00:00 | 2013-04-01 00:00:00 | 2009-05-01 00:00:00 | 2011-01-01 00:00:00 |  |  | 2009-05-01 00:00:00 | 2011-01-01 00:00:00
2010-10-01 00:00:00 | 2018-10-01 00:00:00 | 2011-11-01 00:00:00 | 2013-07-01 00:00:00 |  |  | 2011-11-01 00:00:00 | 2013-07-01 00:00:00
2005-01-01 00:00:00 | 2012-03-30 00:00:00 | 2006-02-01 00:00:00 | 2007-10-01 00:00:00 |  |  | 2006-02-01 00:00:00 | 2007-10-01 00:00:00
2009-01-01 00:00:00 | 2013-01-01 00:00:00 | 2010-02-01 00:00:00 | 2011-10-01 00:00:00 |  |  | 2010-02-01 00:00:00 | 2011-10-01 00:00:00
2008-10-01 00:00:00 | 2015-05-01 00:00:00 | 2009-11-01 00:00:00 | 2011-07-01 00:00:00 |  |  | 2009-11-01 00:00:00 | 2011-07-01 00:00:00
2009-01-01 00:00:00 | 2013-01-01 00:00:00 | 2010-02-01 00:00:00 | 2011-10-01 00:00:00 |  |  | 2010-02-01 00:00:00 | 2011-10-01 00:00:00
2010-01-01 00:00:00 | 2013-01-01 00:00:00 | 2011-02-01 00:00:00 | 2012-10-01 00:00:00 |  |  | 2011-02-01 00:00:00 | 2012-10-01 00:00:00
- Also how would I set up column ‘D’ to automatically turn the background in the cell Green if the date in that cell is before the date in the column ‘B’, turn Orange if the date in that cell is a month past the date in column ‘B’ and turn Red if the date in that cell is more than a month past the date in column ‘B’.