上下左右交叉 顯示 (14601)

(先)格式化 A1:O15=(COLUMN(A1)>=$R$2-1)*(COLUMN(A1)<=$R$2+1)

(先)格式化 A1:O15=(ROW(A1)>=$R$2-1)*(ROW(A1)<=$R$2+1)

(後)格式化 A1:O15=(COLUMN(A1)>=$R$2-1)*(COLUMN(A1)<=$R$2+1)*(ROW(A1)>=$R$2-1)*(ROW(A1)<=$R$2+1)



留言