Minimum value across multiple rows, conditionally formatted

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:

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?

• Does this answer your question? Conditionally formatting the minimum value in a row 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 :( 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. Jun 16, 2021 at 23:41

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