formula based on font colour

[JobiBanana]

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"...)

[Pete_UK]

What conditional formatting rules have you set up for those answers, or have you just coloured them manually?

Pete

[JobiBanana]

sorry, I wrote that wrong! the answers are coloured manually, but they're used in the macro (not conditional formatting) at one point simply to sort by font colour.

[Pete_UK]

they're used in the macro (not conditional formatting) at one point simply to sort by font colour.

Well, you must have a routine within your macro that returns the font colour. If this is defined as a function then you could make use of it in the way you suggested. Post a copy of that routine.

Pete