Spreadsheet: 66173d1266875575-using-a-formula-in-conditional-formatting-not-working-circuit-tracker-for-question-try-1
Sheet: Sheet1

Priority | Project Health | Project | Circuit | Baseline FOC Date | Current FOC | [NAME] | Baseline Circuit Extension Date | Circuit Extension Date | [NAME]?
Critical | Yellow | Project 1 | Circuit 1 | 2009-10-30 00:00:00 |  | Yes |  |  | Yes
High | Yellow | Project 2 | Circuit 2 | 2009-09-21 00:00:00 |  | Yes |  |  | Yes
Critical | Yellow | Project 3 | Circuit 3 | 2009-11-30 00:00:00 |  | Yes |  |  | Yes
Critical | Yellow | Project 4 | Circuit 4 | 2009-12-21 00:00:00 |  | Yes |  |  | Yes
Critical | Yellow | Project 5 | Circuit 5 | 2010-01-20 00:00:00 |  | Yes |  |  | Yes
Critical | Yellow | Project 6 | Circuit 6 | 2009-10-30 00:00:00 |  | Yes |  |  | Yes
Critical | Yellow | Project 7 | Circuit 7 | 2010-01-20 00:00:00 |  | Yes |  |  | Yes
Critical | Yellow | Project 8 | Circuit 8 | 2009-10-30 00:00:00 |  | Yes |  |  | Yes
Critical | Yellow | Project 9 | Circuit 9 | 2010-01-20 00:00:00 |  | Yes |  |  | Yes
Critical | Yellow | Project 10 | Circuit 10 | 2009-10-30 00:00:00 |  | Yes |  |  | Yes
Critical | Yellow | Project 11 | Circuit 11 | 2010-01-20 00:00:00 |  | No |  |  | No
Critical | Yellow | Project 12 | Circuit 12 | 2009-10-30 00:00:00 |  | Yes |  |  | Yes
Critical | Yellow | Project 13 | Circuit 13 | 2010-01-20 00:00:00 |  | No |  |  | No
Critical | Yellow | Project 14 | Circuit 14 | 2010-02-02 00:00:00 |  | Yes |  |  | Yes
Critical | Yellow | Project 15 | Circuit 15 | 2010-01-15 00:00:00 |  | No |  |  | No
Critical | Green | Project 16 | Circuit 16 | 2009-11-11 00:00:00 |  | Yes |  |  | Yes
Critical | Yellow | Project 17 | Circuit 17 | 2010-01-21 00:00:00 |  | No |  |  | No
Critical | Yellow | Project 18 | Circuit 18 | 2010-01-29 00:00:00 |  | Yes |  |  | Yes
Critical | Yellow | Project 19 | Circuit 19 | 2009-11-30 00:00:00 |  | No |  |  | No
Critical | Yellow | Project 20 | Circuit 20 | 2010-01-25 00:00:00 |  | No |  |  | No
Critical | Yellow | Project 21 | Circuit 21 | 2009-11-30 00:00:00 |  | No |  |  | No
Critical | Yellow | Project 22 | Circuit 22 | Pending |  | Yes |  |  | Yes
Critical | Yellow | Project 24 | Circuit 24 | 2009-12-08 00:00:00 |  | Yes |  |  | Yes
Critical | Red | Project 25 | Circuit 25 | 2009-08-12 00:00:00 |  | Yes |  |  | Yes
Critical | Red | Project 26 | Circuit 26 | 2009-09-04 00:00:00 |  | No |  |  | No
Critical | Green | Project 27 | Circuit 27 | 2009-12-10 00:00:00 |  | No |  |  | No
Critical | Green | Project 28 | Circuit 28 | 2009-12-10 00:00:00 |  | Yes |  |  | Yes
Medium | Green | Project 29 | Circuit 29 | 2010-02-05 00:00:00 |  | No |  |  | No
Critical | Green | Project 30 | Circuit 30 | Pending |  | Yes |  |  | Yes
Medium | Green | Project 31 | Circuit 31 | 2010-02-05 00:00:00 |  | No |  |  | No
Critical | Green | Project 32 | Circuit 32 | 2010-01-13 00:00:00 |  | Yes |  |  | Yes
Critical | Green | Project 33 | Circuit 33 | 2010-01-15 00:00:00 |  | No |  |  | No
Critical | Green | Project 34 | Circuit 34 | 2010-01-30 00:00:00 |  | No |  |  | No
Critical | Green | Project 35 | Circuit 35 | 2010-01-30 00:00:00 |  | Yes |  |  | Yes
High | Green | Project 37 | Circuit 37 | 2010-04-08 00:00:00 |  | No |  |  | No
Critical | Green | Project 38 | Circuit 38 | 2009-12-18 00:00:00 |  | No |  |  | No
Critical | Green | Project 39 | Circuit 39 | 2010-01-30 00:00:00 |  | No |  |  | No
High | Green | Project 40 | Circuit 40 | 2010-02-08 00:00:00 |  | Yes |  |  | Yes
High | Green | Project 41 | Circuit 41 | 2010-03-01 00:00:00 |  | No |  |  | No
Medium | Green | Project 42 | Circuit 42 | 2009-04-01 00:00:00 |  | Yes |  |  | Yes
Medium | Green | Project 43 | Circuit 43 | 2009-05-13 00:00:00 |  | No |  |  | No
Medium | Green | Project 44 | Circuit 44 | 2009-05-29 00:00:00 |  | Yes |  |  | Yes
Medium | Green | Project 45 | Circuit 45 | 2009-06-05 00:00:00 |  | No |  |  | No
Medium | Green | Project 46 | Circuit 46 | 2009-06-18 00:00:00 |  | No |  |  | No
Medium | Green | Project 47 | Circuit 47 | Pending |  | No |  |  | No
Medium | Green | Project 48 | Circuit 48 | Pending |  | No |  |  | No
Medium | Green | Project 49 | Circuit 49 |  |  | No |  |  | No
Medium | Green | Project 50 | Circuit 50 | 2009-12-04 00:00:00 |  | No |  |  | No
Medium | Green | Project 51 | Circuit 51 | 2009-08-18 00:00:00 |  | No |  |  | No
High | Green | Project 52 | Circuit 52 | 2009-07-31 00:00:00 |  | No |  |  | No
Low | Green | Project 53 | Circuit 53 | 2009-10-13 00:00:00 |  | No |  |  | No
Low | Green | Project 54 | Circuit 54 | 2009-10-15 00:00:00 |  | No |  |  | No
Critical | Red | Project 55 | Circuit 55 | 2009-11-20 00:00:00 |  | Yes |  |  | Yes
Critical | Green | Project 56 | Circuit 56 | 2009-12-20 00:00:00 |  | Yes |  |  | Yes
Critical | Yellow | Project 57 | Circuit 57 | 2009-11-17 00:00:00 |  | Yes |  |  | Yes
Critical | Red | Project 58 | Circuit 58 | 2009-09-28 00:00:00 |  | Yes |  |  | Yes
Critical | Green | Project 59 | Circuit 59 | 2009-11-02 00:00:00 |  | Yes |  |  | Yes
Critical | Green | Project 60 | Circuit 60 | 2009-09-21 00:00:00 |  | No |  |  | No
Critical | Green | Project 61 | Circuit 61 |  |  | No |  |  | No
Low | Green | Project 62 | Circuit 62 |  |  | No |  |  | No
Low | Green | Project 63 | Circuit 63 |  |  | No |  |  | No
Critical | Red | Project 68 | Circuit 68 | 2010-02-18 00:00:00 |  | Yes |  |  | Yes
Critical | Red | Project 69 | Circuit 69 | 2010-02-17 00:00:00 |  | Yes |  |  | Yes
Critical | Red | Project 70 | Circuit 70 | pending |  | Yes |  |  | Yes
Critical | Red | Project 71 | Circuit 71 | 2010-02-18 00:00:00 |  | No |  |  | No
Low | Yellow | Project 76 | Circuit 76 | 2009-09-30 00:00:00 |  | No |  |  | No
Critical | Yellow | Project 77 | Circuit 77 | pending |  | No |  |  | No
Critical | Green | Project 78 | Circuit 78 | 2009-12-21 00:00:00 |  | No |  |  | No
Critical | Green | Project 79 | Circuit 79 | 2010-01-15 00:00:00 |  | No |  |  | No
Medium | Green | Project 121 | Circuit 121 | 2010-04-15 00:00:00 |  | No |  |  | No
Medium | Green | Project 193 | Circuit 193 | 2009-12-10 00:00:00 |  |  |  |  | No
 | Green | Project 195 | Circuit 195 | 2009-09-08 00:00:00 |  |  |  |  | No
 | Green | Project 196 | Circuit 196 | 2009-09-04 00:00:00 |  |  |  |  | No
 | Green | Project 197 | Circuit 197 | 2009-09-04 00:00:00 |  |  |  |  | No
 | Green | Project 198 | Circuit 198 | 2009-11-02 00:00:00 |  |  |  |  | No
 | Green | Project 199 | Circuit 199 | 2009-10-30 00:00:00 |  |  |  |  | No
 | Green | Project 200 | Circuit 200 | 2009-11-02 00:00:00 |  |  |  |  | No
 | Green | Project 201 | Circuit 201 | 2009-12-31 00:00:00 |  |  |  |  | No
 | Green | Project 202 | Circuit 202 | 2009-12-16 00:00:00 |  |  |  |  | No
 | Green | Project 203 | Circuit 203 | 2009-12-31 00:00:00 |  |  |  |  | No
 | Green | Project 204 | Circuit 204 | 2009-12-31 00:00:00 |  |  |  |  | No
 | Green | Project 205 | Circuit 205 | 2009-11-30 00:00:00 |  |  |  |  | No
 | Green | Project 206 | Circuit 206 | 2009-12-31 00:00:00 |  |  |  |  | No
 | Green | Project 207 | Circuit 207 | 2010-01-04 00:00:00 |  |  |  |  | No
High | Green | Project 208 | Circuit 208 | 2010-03-05 00:00:00 |  |  |  |  | No
High | Green | Project 209 | Circuit 209 | pending |  | Yes |  |  | Yes
High | Green | Project 210 | Circuit 210 | 2010-03-09 00:00:00 |  | Yes |  |  | Yes
High | Green | Project 211 | Circuit 211 | 2010-04-11 00:00:00 |  | Yes |  |  | Yes