Forum Discussion
Conditional Formatting - Consider Only Value as Lowest Value
Hi Ben,
More exactly blank cells are ignored in any case. If you have only one value it is simultaneously min and max value in the range, Excel goes from min to max and shows you that one number as the biggest one.
If you'd like to show it as the lowest you shall reverse "the axis" and if that is the only number add to it something compare reversed minimum, like this
where formula for minimum is
=MAX($A$1:$A$10)+(COUNTA($A$1:$A$10)=1)
and for maximum
=MIN($A$1:$A$10)
If you have more than one number colour grade will be correct (min is darker for our scale)
and attached
Hi Ben,
More exactly blank cells are ignored in any case. If you have only one value it is simultaneously min and max value in the range, Excel goes from min to max and shows you that one number as the biggest one.
If you'd like to show it as the lowest you shall reverse "the axis" and if that is the only number add to it something compare reversed minimum, like this
where formula for minimum is
=MAX($A$1:$A$10)+(COUNTA($A$1:$A$10)=1)
and for maximum
=MIN($A$1:$A$10)
If you have more than one number colour grade will be correct (min is darker for our scale)
and attached
That said, it works beautifully. Thank you!