Ability to Set the Middle-Point Value When Using Custom Range in Conditional Formatting

[vvaezian]

[This makes more sense for the three-color ranges (e.g. red-white-green) but it is useful for two-color ranges as well]

When we use custom range in conditional formatting, we can set the values for start and end of the range. The middle point is then calculated as the average of these two values. It would be nice to be able to manually set the middle-point. for example if I have a column that ranges from -5 to +30, I would like to make all positive values green and all negative values red where -5 is the darkest red and +30 is the darkest green, and 0 be white. Currently this is not possible. The best I can do is to set the end range at +5, which will make all values greater than 5 the same dark green.

[duc-ctm-jacobins-digital]

This feature would help my company a lot. End-users see comparison all the times, and I can not visualize positive/negative in 2 colors.