When I put the formula =MAX(FILTER(I2:I,H2:H=MIN(H2:H)))
in cell M2
and use =$I1=$M$2
in conditional formatting custom function it paints the entire line perfectly, but when I use the formula inside the conditional formatting custom function like this =$I1=MAX(FILTER(I2:I,H2:H=MIN(H2:H)))
, nothing is painted.
What do I need to adjust for this to resolve?
try:
=$I2=MAX(FILTER($I$2:$I, $H$2:$H=MIN($H$2:$H)))