Spreadsheet: 66165d1266873545-using-a-formula-in-conditional-formatting-not-working-circuit-tracker-for-question
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 | 10/30/2009 |  | Yes |  |  | Yes
High | Yellow | Project 2 | Circuit 2 | 09/21/2009 |  | Yes |  |  | Yes
Critical | Yellow | Project 3 | Circuit 3 | 11/30/2009 |  | Yes |  |  | Yes
Critical | Yellow | Project 4 | Circuit 4 | 12/21/2009 |  | Yes |  |  | Yes
Critical | Yellow | Project 5 | Circuit 5 | 1/20/2010 |  | Yes |  |  | Yes
Critical | Yellow | Project 6 | Circuit 6 | 10/30/2009 |  | Yes |  |  | Yes
Critical | Yellow | Project 7 | Circuit 7 | 1/20/2010 |  | Yes |  |  | Yes
Critical | Yellow | Project 8 | Circuit 8 | 10/30/2009 |  | Yes |  |  | Yes
Critical | Yellow | Project 9 | Circuit 9 | 1/20/2010 |  | Yes |  |  | Yes
Critical | Yellow | Project 10 | Circuit 10 | 10/30/2009 |  | Yes |  |  | Yes
Critical | Yellow | Project 11 | Circuit 11 | 1/20/2010 |  | No |  |  | No
Critical | Yellow | Project 12 | Circuit 12 | 10/30/2009 |  | Yes |  |  | Yes
Critical | Yellow | Project 13 | Circuit 13 | 1/20/2010 |  | No |  |  | No
Critical | Yellow | Project 14 | Circuit 14 | 2/2/2010 |  | Yes |  |  | Yes
Critical | Yellow | Project 15 | Circuit 15 | 1/15/2010 |  | No |  |  | No
Critical | Green | Project 16 | Circuit 16 | 11/11/2009 |  | Yes |  |  | Yes
Critical | Yellow | Project 17 | Circuit 17 | 1/21/2010 |  | No |  |  | No
Critical | Yellow | Project 18 | Circuit 18 | 1/29/2010 |  | Yes |  |  | Yes
Critical | Yellow | Project 19 | Circuit 19 | 11/30/2009 |  | No |  |  | No
Critical | Yellow | Project 20 | Circuit 20 | 1/25/2010 |  | No |  |  | No
Critical | Yellow | Project 21 | Circuit 21 | 11/30/2009 |  | No |  |  | No
Critical | Yellow | Project 22 | Circuit 22 | Pending |  | Yes |  |  | Yes
Critical | Yellow | Project 24 | Circuit 24 | 12/08/2009 |  | Yes |  |  | Yes
Critical | Red | Project 25 | Circuit 25 | 08/12/2009 |  | Yes |  |  | Yes
Critical | Red | Project 26 | Circuit 26 | 09/04/2009 |  | No |  |  | No
Critical | Green | Project 27 | Circuit 27 | 12/10/2009 |  | No |  |  | No
Critical | Green | Project 28 | Circuit 28 | 12/10/2009 |  | Yes |  |  | Yes
Medium | Green | Project 29 | Circuit 29 | 02/5/2010 |  | No |  |  | No
Critical | Green | Project 30 | Circuit 30 | Pending |  | Yes |  |  | Yes
Medium | Green | Project 31 | Circuit 31 | 02/5/2010 |  | No |  |  | No
Critical | Green | Project 32 | Circuit 32 | [NAME] |  | Yes |  |  | Yes
Critical | Green | Project 33 | Circuit 33 | 1/15/2010 |  | No |  |  | No
Critical | Green | Project 34 | Circuit 34 | 01/30/2010 |  | No |  |  | No
Critical | Green | Project 35 | Circuit 35 | 1/30/2010 |  | Yes |  |  | Yes
High | Green | Project 37 | Circuit 37 | 04/08/2010 |  | No |  |  | No
Critical | Green | Project 38 | Circuit 38 | 12/18/2009 |  | No |  |  | No
Critical | Green | Project 39 | Circuit 39 | 1/30/2010 |  | No |  |  | No
High | Green | Project 40 | Circuit 40 | 02/8/2010 |  | Yes |  |  | Yes
High | Green | Project 41 | Circuit 41 | 03/01/2010 |  | No |  |  | No
Medium | Green | Project 42 | Circuit 42 | 04/01/2009 |  | Yes |  |  | Yes
Medium | Green | Project 43 | Circuit 43 | 05/13/2009 |  | No |  |  | No
Medium | Green | Project 44 | Circuit 44 | 05/29/2009 |  | Yes |  |  | Yes
Medium | Green | Project 45 | Circuit 45 | 06/05/2009 |  | No |  |  | No
Medium | Green | Project 46 | Circuit 46 | 06/18/2009 |  | 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 | 12/04/2009 |  | No |  |  | No
Medium | Green | Project 51 | Circuit 51 | 08/18/2009 |  | No |  |  | No
High | Green | Project 52 | Circuit 52 | 07/31/2009 |  | No |  |  | No
Low | Green | Project 53 | Circuit 53 | 10/13/09 |  | No |  |  | No
Low | Green | Project 54 | Circuit 54 | 10/15/09 |  | No |  |  | No
Critical | Red | Project 55 | Circuit 55 | 11/20/2009 |  | Yes |  |  | Yes
Critical | Green | Project 56 | Circuit 56 | 12/20/2009 |  | Yes |  |  | Yes
Critical | Yellow | Project 57 | Circuit 57 | 11/17/2009 |  | Yes |  |  | Yes
Critical | Red | Project 58 | Circuit 58 | 09/28/2009 |  | Yes |  |  | Yes
Critical | Green | Project 59 | Circuit 59 | 11/2/2009 |  | Yes |  |  | Yes
Critical | Green | Project 60 | Circuit 60 | 09/21/2009 |  | 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 | 2/18/2010 |  | Yes |  |  | Yes
Critical | Red | Project 69 | Circuit 69 | 2/17/2010 |  | Yes |  |  | Yes
Critical | Red | Project 70 | Circuit 70 | pending |  | Yes |  |  | Yes
Critical | Red | Project 71 | Circuit 71 | 2/18/2010 |  | No |  |  | No
Low | Yellow | Project 76 | Circuit 76 | 09/30/2009 |  | No |  |  | No
Critical | Yellow | Project 77 | Circuit 77 | pending |  | No |  |  | No
Critical | Green | Project 78 | Circuit 78 | 12/21/2009 |  | No |  |  | No
Critical | Green | Project 79 | Circuit 79 | [NAME] |  | No |  |  | No
Medium | Green | Project 121 | Circuit 121 | 4/15/2010 |  | No |  |  | No
Medium | Green | Project 193 | Circuit 193 | 12/10/2009 |  |  |  |  | No
 | Green | Project 195 | Circuit 195 | 9/8/09 |  |  |  |  | No
 | Green | Project 196 | Circuit 196 | 9/4/09 |  |  |  |  | No
 | Green | Project 197 | Circuit 197 | 9/4/09 |  |  |  |  | No
 | Green | Project 198 | Circuit 198 | 11/2/2009 |  |  |  |  | No
 | Green | Project 199 | Circuit 199 | 10/30/09 |  |  |  |  | No
 | Green | Project 200 | Circuit 200 | 11/2/09 |  |  |  |  | No
 | Green | Project 201 | Circuit 201 | 12/31/2009 |  |  |  |  | No
 | Green | Project 202 | Circuit 202 | 12/16/2009 |  |  |  |  | No
 | Green | Project 203 | Circuit 203 | 12/31/2009 |  |  |  |  | No
 | Green | Project 204 | Circuit 204 | 12/31/2009 |  |  |  |  | No
 | Green | Project 205 | Circuit 205 | 11/30/2009 |  |  |  |  | No
 | Green | Project 206 | Circuit 206 | 12/31/2009 |  |  |  |  | No
 | Green | Project 207 | Circuit 207 | 1/4/2010 |  |  |  |  | No
High | Green | Project 208 | Circuit 208 | 3/5/2010 |  |  |  |  | No
High | Green | Project 209 | Circuit 209 | pending |  | Yes |  |  | Yes
High | Green | Project 210 | Circuit 210 | 3/9/2010 |  | Yes |  |  | Yes
High | Green | Project 211 | Circuit 211 | 4/11/2010 |  | Yes |  |  | Yes