Spreadsheet: 732943d1621331591-conditional-formatting-not-working-2020-21-ks4-studentprogressdata-example
Sheet: Year 10 WIP

 |  |  |  | COLUMNS TO BE HIDDEN ONCE DATA ENTERED
 |  |  |  | [NAME] SCORES FOR EACH SUBJECT - but not BTEC subjects or Photography! |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Attainment
PUPIL | Form | Yellis Score | Expected Level | Yellis Pred. Art & Design | [NAME]. Biology | Yellis Pred. Business Studies | Yellis Pred. Chemistry | Yellis Pred. Computer Science | [NAME]. D&T | [NAME]. Drama | [NAME]. [NAME] | [NAME]. English Lit | [NAME]. French | [NAME]. Geography | [NAME]. German | [NAME]. History | [NAME]. Maths | [NAME]. Music | Music Technoogy | [NAME]. PE | Yellis Pred. Physics | [NAME]. RE | [NAME]. Spanish | Yellis Pred. Travel & Tourism |  | [NAME]. Combined Science | Yellis Pred. Sports Science |  | Av actual level | Difference | Expected no. grades (subjects studied) | No. grades input | Art & Design | Biology | Business Studies | Chemistry | Computer Science | D&T | Drama | English [NAME] | English Lit | French | Geography | German | History | Maths | Music | Music Technology | PE | Physics | RE | Spanish | Travel & Tourism | Combined Science | Sports Science
X | 10Gi | 97 |  | 5 | 5 | 4 | 5 | 3 | 5 | 5 | 5 | 5 | 4 | 4 | 4 | 5 | 4 | 5 |  | 5 | 5 | 5 | 4 |  |  | 5 |  |  |  |  | 11 |  | 5 | 8 |  | 3 |  | 5 |  | 5 | 5 |  |  |  |  | 3 |  | M |  | 4 |  | 3
X | 10Ga | 108 |  | 6 | 6 | 5 | 6 | 5 | 5 | 5 | 6 | 6 | 5 | 6 | 5 | 6 | 6 | 6 |  | 6 | 6 | 6 | 5 |  |  | 6 |  |  |  |  | 10 |  |  | 8 |  | 7 |  |  |  | 5 | 5 |  | 5 |  | 5 | 5 | 6 |  |  | 6 |  | 4
X | 10Ga | 113 |  | 6 | 6 | 6 | 6 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 5 | 6 | 6 | 6 |  | 6 | 6 | 6 | 6 |  |  | 6 |  |  |  |  | 10 |  | 5 | 8 | 5 | 6 |  |  |  | 6 | 6 | 5 |  |  |  | 7 |  |  |  | 8 |  | 5
X | 10M | 112 |  | 6 | 6 | 6 | 6 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 5 | 6 | 6 | 6 |  | 6 | 6 | 6 | 6 |  |  | 6 |  |  |  |  | 11 |  |  | 9 | 4 | 4 |  |  | 5 | 5 | 6 |  | 6 |  |  | 5 |  |  |  | 4 |  | 3
X | 10M | 109 |  | 6 | 6 | 5 | 6 | 5 | 6 | 5 | 6 | 6 | 5 | 6 | 5 | 6 | 6 | 6 |  | 6 | 6 | 6 | 5 |  |  | 6 |  |  |  |  | 10 |  |  | 9 |  | 7 |  | 5 |  | 5 | 5 |  | 6 |  | 5 | 7 |  |  |  | 8
X | 10Gi | 97 |  | 5 | 5 | 4 | 5 | 3 | 5 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 5 |  | 5 | 5 | 5 | 4 |  |  | 5 |  |  |  |  | 10 |  | 4 | 1 | 4 | 2 |  |  | 5 | 5 | 5 |  |  |  |  | 3 |  |  |  | 2 | 4
X | 10Gi | 81 |  | 4 | 4 | 2 | 4 | 2 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 4 |  | 4 | 3 | 3 | 3 |  |  | 3 |  |  |  |  | 11 |  |  | 3 | 3 | 4 |  | 3 |  | 4 | 4 |  |  |  | 2 | 3 |  |  | 4 | 4
X | 10Ga | 115 |  | 6 | 7 | 6 | 7 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 5 | 6 | 6 | 6 |  | 6 | 7 | 6 | 6 |  |  | 6 |  |  |  |  | 10 |  |  | 6 | 4 | 4 |  | 4 |  | 5 | 6 |  |  |  |  | 4 |  | M | 4 | 3
X | 10Gi | 108 |  | 6 | 6 | 5 | 6 | 5 | 5 | 5 | 6 | 6 | 5 | 6 | 5 | 6 | 6 | 6 |  | 6 | 6 | 6 | 5 |  |  | 6 |  |  |  |  | 10 |  |  | 8 | 5 | 6 | 6 |  |  | 5 | 5 |  | 5 |  |  | 5 |  | DI |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | What I need: |  | Preferably column AG should turn the cell red if the number of grades input is less than the expected number of grades
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column AG has formulas in the cells to count the number of cells that have a grade entered
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Is it possible to conditionally format a cell that contains a formua?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I've tried and it won’t work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | However, I have also tried formatting column AF so that if it is more than column AG, it turns red and this is not working either
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | It's almost like conditional formatting won't work on the sheet!