Conditional formatting in Excel: substituting cell values but leaving original coloring doesnot

I want to format my cells in a way, where the colors are displayed according the the color-rule as in column 1 but the values that you see within the colored area are the ones of column 2.

Column 1 displays %change from a reference. I formatted column 1 with the 3-color rule (lowest=-20, middle=0, highest=+20).

Column 2 gives the originally measured values.

Now I want to substitute the values in column 1 by the ones in column 2, but leave the original "column 1 color formatting" in order to use the coloring as additional information.

I tried the "formula" formatting by marking the colored values in column 1 as =SUM(values column 2), but then the original coloring is gone and the values are still %change.

Recent Questions...