I’d like a color scale which middle color is “unmixed”, at full color, on the median; in my specific case, green for min, white for median, and red for max. It turn out that there is 2 numbers closest to the median, so I’d like both to be completely white if possible; all the rest mixed with green or red depending if it’s going toward the min or max.
I first tried switching the middle criteria from percentage 50 to formula MEDIAN() in vain, by doing so there was no green and the only colors were a mix of white and red. I then played with formulas in vain as in
question-color_scale_median.ods (14.4 KB)
Thank you kindly for your help