撞球到左右邊緣 直角往下 格式化 (15294)

X2:X3=CHAR(RANDBETWEEN(65,84))

B2:U21格式化=IF($X$3<$X$2,-1^($X$3<$X$2)*(ROW(A1)-1)+CODE($X$2)-64+IF(ROW(A1)>CODE($X$2)-64,(ROW(A1)-(CODE($X$2)-64))*2,),-1^($X$3<$X$2)*(ROW(A1)-1)+CODE($X$2)-64-IF(ROW(A1)>20-(CODE($X$2)-64)+1,(ROW(A1)+CODE($X$2)-64-21)*2,))=COLUMN(A1)