Excel VBA for cell colour format to carry over to another sheet

[XanderTheNotSoAwesome]

I have a sheet, let’s call it “Results”.
On this sheet there are many columns for each category: “Science”, “Math” and so on so forth.
each individual student are named on the rows.

Eg: Working Sheet
Science Math
Student A 70(LGreen) 20 (Red)
Student B 66.5(LYellow) 45.68(Dark Yellow)
…..
Student Z 10(Red) 10 (Red)

Hopefully any helpful souls can visualise this.

I am given this sheet with the cells coloured based on some macro that I am not informed of (confidentiality).

I have a set of macros that automatically ranks each student based on their overall score. But when I use the macro, all the colour fills disappear. (I want to keep the colour fill for the final sheet, is there a code that copies the colour codes from the working sheet to this final sheet?)

Eg: Final Sheet
Science Math
Student F 96 92
Student D 91 86
…..
Student Z 10 10

Student F had DarkGreen for both Science and Math
Student D had DarkGreen for Science and Lightgreen for Math
Student Z had both Red.
But on the final sheet it is not coloured.

Any idea how I can do this? Much thanks appreciated for any help!

 

[XanderTheNotSoAwesome]

tldr; can I carry over the colour fills for the cell values on one sheet over to another even though the arrangements are different for both? (Cell values are exactly the same though)