Dear All

I have a spreadsheet which lists students, their target grade and their actual grade as follows:

Person 1 | A | C
Person 2 | B | B
Person 2 | C | B

etc etc

Please can you help me:

1) Highlight as red those grades which are on target or above target;
2) Leave as white those grades which are one grade below target;
3) Highlight as blue those grades which are two or more grades below target;
4) Count the number of 'red' students and the number of 'blue' students.

I would be very grateful for any help/advice you can offer.

Many thanks

Daniel