上下左右 隨數字顯色格數 (9699)

格式化 E2:M13SUMPRODUCT(N(ABS(ABS(ROW(A1)-ROW($1:$9))-1)<E$5:E$13))+SUMPRODUCT(N(ABS(ABS(COLUMN(A1)-COLUMN($A:$I))-1)<$E5:$M5))+(E5>0)

儲存後 下載須重設{=OR(E$5:E$13>ABS(ABS(ROW(A1)-ROW($1:$9))-1),$E5:$M5>ABS(ABS(COLUMN(A1)-COLUMN($A:$I))-1))+(E5>0)