Hi

I have a worksheet which calculates a running average of student test
scores. An adjacent cell then has a vlookup function that displays a
grade based on the average test score and the level of the paper. The
grades are a mixture on numbers and letters, thus;

6a
6b
6c
5a
5b
5c
4a
4b

I have to provide "encouraging feedback" to the students after every
paper and report on whether their grade has gone up or down. My
problem is that the grade field changes instantly I type in the latest
score. Is there any way that I could flag up a change of grade, and
whether it was an improvement or not,perhaps by changing the colour
formatting of the grade displayed.

Any help would be greatly appreciated,

Dave