Here is an example of 4 cells in my workbook.
26 99 2 1
The workbook is coloured according to the rules 100=red 0=yellow, where things closer to 0 are more yellow and things closer to 100 are more red (This is defined by a conditional formatting rule that assigns colours based on value).
In this example 99 would be very red, 1 and 2 would be very yellow and 26 would have an orange tinge.
I want to keep the colour of the cells the same but change the values in the cells. In this example I want them to be
E=0.0,Q=26 E=0.0,Q=99 E=2.10e-11,Q=2 E=1.02e-08,Q=1
(Notice how the values on the right side of the q are the same as the first matrix)
Because of the conditional formatting rule my colours disappear when I paste new values into them.