Can conditional formatting or a programmed expression with excel be used to achieve this? (if the answer is yes, with a few pointers given, I can get my teeth into it)
A spreadsheet is used to stored the skill level of pupils for a subject.
Skill levels are as such:
and so on, up to 5C, 5B, 5A.
I need to setup excel so that it automatically colour codes the background of a cell to indicate if progress has been made. For example, in the Autumn term for maths, a pupil was skill level 1B. In Spring term they were 1A. (so they have gone up in skill, deamed by the test). In this instance, I would like the cell with 1A in it to be green, to indicate visually that progress has been made. If however they had gone backward to 1C, I would like this cell with 1C shown, to be red.
Autumn Spring Summer
1B 1A 1B
Can this be done? (If not, can it be achieve in a roundabout way?)