Dear all, I wonder if anyone can help
I'm setting up a grading spreadsheet. This will use a UK levelling system where the grades (in ascending order) are...
1c 1b 1a 2c 2b 2a --> and so on up to 7a
I have the spreadsheet using a lookup table to convert the inputted grades into numbers - and then am using formulae to average, and then another lookup table to give an average level achieved so far.
However, I'd really like it if I could then compare the average level (eg 3a) with the pupils target level (eg 2a), and then format the average level to show that it is higher than the target, lower etc.
Conditonal formatting seems to be the way to do it, however I cannot get this to work at present on the 2 grades. I can convert both to numerical scores and then use conditonal formatting - but I would prefer to hide these columns and just leave my users with the scores
Any help greatfully received
I'm setting up a grading spreadsheet. This will use a UK levelling system where the grades (in ascending order) are...
1c 1b 1a 2c 2b 2a --> and so on up to 7a
I have the spreadsheet using a lookup table to convert the inputted grades into numbers - and then am using formulae to average, and then another lookup table to give an average level achieved so far.
However, I'd really like it if I could then compare the average level (eg 3a) with the pupils target level (eg 2a), and then format the average level to show that it is higher than the target, lower etc.
Conditonal formatting seems to be the way to do it, however I cannot get this to work at present on the 2 grades. I can convert both to numerical scores and then use conditonal formatting - but I would prefer to hide these columns and just leave my users with the scores
Any help greatfully received