I need help understanding how the MIN formula mixes with conditional formatting, cause I can't wrap my head around it.

Here's specific situation: enter image description here

I've successfully got formatting for minimum across just the row (bold, blue) -- it uses the strange "Is equal to" with =min(55:55) .

Anyway, now I also want the minimum across all those rows to be red fill. Shown in image are a bunch of erroneously filled numbers. In this case just the cell H64, with value 54, should be filled red.

I've tried different variations of "Is equal to" , "Less than or equal to" =min(F54:M67) , to no avail.

How to get minimum value across multiple rows to be conditionally formatted?

  • 1
    Does this answer your question? Conditionally formatting the minimum value in a row
    – Tedinoz
    Jun 16, 2021 at 2:26
  • @Tedinoz Not a duplicate: min in rectangular range vs. min in row, use compare vs. use custom formula. Jun 16, 2021 at 5:20
  • @doubleunary Thank you. You're absolutely right. I misread the question :(
    – Tedinoz
    Jun 16, 2021 at 6:05
  • @Tedinoz, I squeaked by previously and managed to get a relative minimum coloring going for a single row. I guess I wanted this behavior previously, cause it was easier to to have it auto-color subsequent rows, as long as the formatted range was big enough. Now, for this current question, I absolutely did need the absolute anchors, and that helps explain!
    – icy
    Jun 16, 2021 at 20:21
  • @icy I find it disappointing that the conditional formatting documentation doesn't deal with the various permutations of cell references. Even when one has a very good understanding of absolute/relative referencing, the implications for conditional formatting are far from intuitive.
    – Tedinoz
    Jun 16, 2021 at 23:41

1 Answer 1


Use Is equal to =min($F$54:$M$67).

See absolute and relative references.

  • Regarding the explanation of cell references, from How do I write a good answer? "Links to external resources are encouraged, but... always quote the most relevant part of an important link, in case the external resource is unreachable or goes permanently offline."
    – Tedinoz
    Jun 16, 2021 at 6:05
  • ty, the absolute ref did it!
    – icy
    Jun 16, 2021 at 20:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.