I need help understanding how the MIN formula mixes with conditional formatting, cause I can't wrap my head around it.
I've successfully got formatting for minimum across just the row (bold, blue) -- it uses the strange "Is equal to" with
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?