I've set up a assortment of conditional formatting and macros to enable my company to automatically create exams in the click of a button, it took a rather long time (my first time using excel in this way) so i'm not too keen on the idea of changing it any time soon, but now I'm trying to set up an automatic marking system where we just input their multiple choice selections and get a direct score from that.

I've got this set up

cvbn.jpg

the correct answer is in a red font (I'd like to not change this as this is part of my conditional formatting set up at another stage).
Ideally i need for the answer to automatically be entered into column E as an "a" "b" or "c" but cannot find a formula for this.

Does anyone know of one? (something along the lines of IF(B2=RED,"a"...)