Hello,
I am currently creating a digital markbook that is colour coded depending on the students' target grade. At the minute I have colour coded it so that if a student receives a grade that is below the target grade, it is red, if it equals their target grade, it goes green and if they go above, it goes purple. This all works well, however, I would like to have it that if their grade is only 1 below their target, it goes yellow. Is this possible? If it is, does anyone know what the formulas would be?
On the example posted, I would like D3, D5, D8, D11 and D13 to be yellow as they are only 1 below their target grade.
I hope that all makes sense!
Thanks in advance!
Bookmarks