Spreadsheet: 193478d1352839854-conditional-formatting-wont-work-on-a-cell-with-a-formula-in-it-someone-please-help-prototype-fix
Sheet: Year 7

UPN | Surname | Forename | Tutor Group | Gender | Date of Birth | Ethnicity Code | SEN Status | Gifted and Talented | Free School Meals | Child in Care | Intervention Strategies |  |  | KS2 |  | CATs |  |  |  | Year 7 Progress
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | English
 |  |  |  |  |  |  |  |  |  |  | Autumn | Spring | Summer | English | Maths | Verbal | Non-Verbal | Quantit-ative | Mean | Teaching Group | Subject Intervention | Baseline | Teacher Assessments |  |  |  |  |  | End of Year Target |  | FFT (end of KS3)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Autumn |  | Spring |  | Summer |  | 3 Levels | 4 Levels
1 | Apple | [NAME] | 1 | F | 2008-09-06 00:00:00 | WBRI | N | Y | N | N | N |  |  | 5C | 4A | 110 | 114 | 112 |  | 2 | N |  | 5B |  |  |  |  |  |  |  | 6A
2 | [NAME] | Beatrice | 2 | F | 2008-11-01 00:00:00 | WBRI | N | N | N | N | N |  |  | 3A | 4C | 95 | 89 | 97 |  | 2 | N |  | 3A |  |  |  |  |  |  |  | 4A
3 | [NAME] | [NAME] | 3 | M | 2009-02-02 00:00:00 | WBRI | N | N | N | N | N |  |  | 4B | 4C | 104 | 101 | 96 |  | 3 | N |  | 4A |  |  |  |  |  |  |  | 6C
4 | Date | Delia | 1 | F | 2008-09-30 00:00:00 | WBRI | A | N | N | N | 1 |  |  | 3B | 3B | 90 | 92 | 89 |  | 3 | N |  | 3C |  |  |  |  |  |  |  | 4B
5 | Elderberry | [NAME] | 2 | M | 2009-06-01 00:00:00 | WBRI | N | N | N | N | N |  |  | 4C | 4C | 99 | 93 | 96 |  | 1 | N |  | 4C |  |  |  |  |  |  |  | 5B
6 | Fig | [NAME] | 3 | F | 2009-04-04 00:00:00 | WBRI | N | N | N | N | N |  |  | 4C | 4B | 100 | 99 | 102 |  | 2 | N |  | 4B |  |  |  |  |  |  |  | 5B
7 | Grape | [NAME] | 1 | M | 2008-12-01 00:00:00 | WBRI | P | N | Y | N | N |  |  | 3C | 3B | 83 | 86 | 89 |  | 1 | N |  | 3C |  |  |  |  |  |  |  | 4C
8 | Honeydew | [NAME] | 2 | F | 2009-03-17 00:00:00 | WBRI | S | N | N | N | N |  |  | 3C | 3C | 76 | 80 | 82 |  | 3 | Y |  | 3C |  |  |  |  |  |  |  | 4C
9 | Illawarra | Issac | 3 | M | 2009-07-23 00:00:00 | WOWB | N | N | N | N | N |  |  | 4B | 4C | 103 | 98 | 98 |  | 1 | N |  | 4A |  |  |  |  |  |  |  | 6C
10 | Jasmine | [NAME] | 1 | F | 2008-10-15 00:00:00 | WBRI | N | N | N | N | 1 |  |  | 4B | 4B | 107 | 100 | 104 |  | 2 | N |  | 4B |  |  |  |  |  |  |  | 6C
11 | Kiwi | Kody | 2 | M | 2009-05-16 00:00:00 | WBRI | N | N | N | N | N |  |  | 4A | 4B | 110 | 101 | 108 |  | 2 | N |  | 5C |  |  |  |  |  |  |  | 5A
12 | Lemon | Lewis | 3 | M | 2009-08-23 00:00:00 | WBRI | A | N | N | N | N |  |  | 3A | 3B | 88 | 84 | 84 |  | 3 | N |  | 3A |  |  |  |  |  |  |  | 4A
13 | Mango | [NAME] | 1 | F | 2009-01-19 00:00:00 | WBRI | N | N | N | N | N |  |  | 3A | 4C | 99 | 91 | 101 |  | 1 | N |  | 3A |  |  |  |  |  |  |  | 4A
14 | Nectarine | Nathan | 2 | M | 2009-06-01 00:00:00 | WBRI | N | Y | N | N | 2 |  |  | 4A | 5C | 122 | 129 | 125 |  | 2 | N |  | 4A |  |  |  |  |  |  |  | 5A
15 | Orange | Olivia | 3 | F | 2009-06-28 00:00:00 | WBRI | N | N | N | CIC | N |  |  | 4C | 4B | 102 | 98 | 97 |  | 3 | N |  | 4B |  |  |  |  |  |  |  | 5B
16 | Pinapple | [NAME] | 1 | M | 2009-03-19 00:00:00 | WBRI | N | N | N | N | N |  |  | 4C | 4B | 101 | 99 | 95 |  | 1 | Y |  | 4C |  |  |  |  |  |  |  | 5B
17 | [NAME] | Qiana | 2 | F | 2009-08-15 00:00:00 | CHKC | A | N | N | N | N |  |  | 3A | 3B | 86 | 92 | 81 |  | 2 | N |  | 3A |  |  |  |  |  |  |  | 4A
18 | [NAME] | [NAME] | 3 | M | 2009-01-09 00:00:00 | WBRI | P | N | Y | N | 3 |  |  | 3B | 3C | 81 | 83 | 83 |  | 1 | N |  | 3B |  |  |  |  |  |  |  | 4B
19 | [NAME] | [NAME] | 1 | F | 2008-12-23 00:00:00 | WBRI | N | N | N | N | N |  |  | 4B | 4A | 105 | 104 | 105 |  | 3 | N |  | 4B |  |  |  |  |  |  |  | 6C
20 | Tangerine | [NAME] | 2 | M | 2009-05-30 00:00:00 | WBRI | N | N | N | N | N |  |  | 4A | 4B | 106 | 104 | 102 |  | 1 | N |  | 5C |  |  |  |  |  |  |  | 5A
21 | Ugli | Urijah | 3 | M | 2008-10-29 00:00:00 | BWBA | N | N | N | N | N |  |  | 3B | 3B | 97 | 94 | 95 |  | 1 | N |  | 3B |  |  |  |  |  |  |  | 4B
22 | Vanilla | Victoria | 1 | F | 2009-04-21 00:00:00 | WBRI | N | Y | N | N | N |  |  | 5C | 5C | 119 | 111 | 126 |  | 2 | N |  | 5B |  |  |  |  |  |  |  | 6A
23 | Watermelon | [NAME] | 2 | F | 2009-02-17 00:00:00 | WBRI | N | N | N | N | 2 |  |  | 4B | 4A | 109 | 107 | 110 |  | 3 | N |  | 4B |  |  |  |  |  |  |  | 6C
24 | Xigua | Xavier | 3 | M | 2009-07-09 00:00:00 | WOWB | N | N | N | N | N |  |  | 4C | 4B | 103 | 96 | 104 |  | 3 | Y |  | 4B |  |  |  |  |  |  |  | 5B
25 | [NAME] | Yvonne | 1 | F | 2008-11-11 00:00:00 | WBRI | P | N | Y | N | N |  |  | 3C | 3C | 78 | 83 | 91 |  | 2 | N |  | 3C |  |  |  |  |  |  |  | 4C
26 | [NAME] | Zayn | 2 | M | 2009-01-05 00:00:00 | WOWB | A | N | N | N | 1 |  |  | 3B | 3B | 88 | 92 | 91 |  | 1 | N |  | 3C |  |  |  |  |  |  |  | 4B