Thread: Conditional Formatting

Hi
In one of my spreadsheets I have conditional formatting. The conditional formatting referes to the grade red for below, green for on target and blue for above target.
However the grade are ranked as for example

3a
3b
3c

with 3a being the highest and 3c being the lowest grade, but when a students target grade is 3b and they are on a 3a for that test it shows up red as if they are performing below target when they are above.

Is there anyway of correcting this so it will rank 3a being the highest grade and 3c being the lowest?

If any suggestion please comment!
Please see attachment to view the spreadsheet