格式化 2个最大或最小的值 (10863)

格式化 I2:K7=CHOOSE(2^(COUNTIF($I2:$K2,">=1")>0),I2>=SMALL($I2:$K2,2),I2<=SMALL($I2:$K2,2))

另解=IF(AND($I2:$K2<1),I2>MIN($I2:$K2),I2<MAX($I2:$K2))