Hi,
in a table of numbers I am trying to highlight the lowest value(s) in red.
I have tried the following formula, but somehow this gives a mixed result;
conditional format question.png
Columns F, K-Q and T give the wrong result, and I don't understand why.
The only other conditional formatting going on here is "if blank, fill grey", thats whats happening in rows 36-40.
Thanks for the help!
Bookmarks