Heatmap (profit and loss) different scale for each row

[rdyaktvt]

Dear Sirs,

I need to paint each heat map row depend on the row's min & max values. Below zero will be red, above zero is green.

If I use one color in option, color changes regarding whole data' s min & max.

If I use color scale range, colors change according option' s min and max. Of course this will not help me, because when one row min is 1 million, other row' s min is only 1. If I set 1 million as min value in color scale option, there is big color differences between 1 million and 1 (of course). But these numbers are in different rows and weights are same. Should bu similar color. Both of them is min number of their own row.

I couldn' t find any solution for different color scale, for each row. Any idea?

Best Regards

[rdyaktvt]

Very strange, no body answer my question.