Copying the colour of one cell to anothers.

[didi]

Hi guys,

I am currently working on an Excel spreadsheet that shows a student's
predicted grades and their 'current' actual grades (these grades have
been pulled in from another sheet in the same workbook so they are
always the most up to date). I have a second column next to the
current grades and the predicted ones, in this column i have assigned
a value to the cell based on the predicted/actual grade i.e. if P then
2, if M then 4, etc.

From this i have then done conditional formatting on the assigned
value so that if the current grade value is less than the predicted it
turns red, if the same orange and above green. From here i then want
to be able to fill the actual grade column with the same colour as the
result of the conditional formatting on the actual grade formatting.

This is the bit that i am stuck on as i can't simply do if cell a is
equal to the value in b then turn green as one is a letter and one a
number. I purely want the colour from the adjacent cell copied so
that we can just have the grades and their colour coding on show not
the grade numbers.

Many Thanks

Didi