格式化 顯最大與最小 (11589)

格式化最大 (藍)=COUNTIFS($B$2:$B$16,$B2,$D$2:$D$16,">"&$D2)=0

格式化最小 (紅)=COUNTIFS($B$2:$B$16,$B2,$D$2:$D$16,"<"&$D2)=0

G2{=MAX(IF(B$2:B$16=F2,D$2:D$16))

H2{=MIN(IF(B$2:B$16=F2,D$2:D$16))