Search code examples
google-sheetsgoogle-sheets-formulaconditional-formatting

MAX + FILTER + MIN functions in a conditional formatting


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?


Solution

  • try:

    =$I2=MAX(FILTER($I$2:$I, $H$2:$H=MIN($H$2:$H)))