Values-specific coloured cells to retain its colour

[XanderTheNotSoAwesome]

Sheet 1: Has values like 33.878 in Yellow, 17.873 in Red and 96.666 in Green.

Is there a way to ensure that these coloured cells are carried over to sheet 2? (Sheet 2 has a macro that sorts out the scores according to percentile and other considerations so I can’t just copy&paste/use simple filtering or sorting and was wondering if there is a code to bring the colours-specific to its value over instead of manually colouring them)

 

[smozgur]

Thanks for helping out with the codes! I managed to get it settled! Much appreciated. You are awesome

Please let us know how you managed to get it settled by posting your own solution, then you can mark it as the solution post.
Otherwise, please mark the best post helping to answer your question.

 

[XanderTheNotSoAwesome]

My mistake, didn’t know I could mark individual posts. I have correctly identified the solution to this thread, thanks and have a nice day!

 

[smozgur]

My mistake, didn’t know I could mark individual posts. I have correctly identified the solution to this thread, thanks and have a nice day!

Thanks for marking the actual solution as it will help future readers.