(先)格式化紅色 A1:M9=(COUNTIF($A:$M,A1)>1)*(MOD(COLUMN(A1),4)=1)
(後)格式化黃色 A1:M9=(COUNTIF($A:$M,A1)>1)*(MOD(COLUMN(A1),4)=1)*(A1=$P$2)
(後)格式化綠色 A1:M9=(COUNTIF($A:$M,A1)>1)*(MOD(COLUMN(A1),4)=1)*(A1=$P$3)