Conditional formatting ignoring Maximum value
I've created conditional formatting based on a three-color range, yellow/orange/red, with the parameters of 180/90/0 for the minimum, middle, and maximum values. (see attachment). It appears Excel is ignoring the maximum value as it is coloring cells yellow when the number in the cell is well over 180.
|