四項均同 顯色 (14865)

A2:D9格式化=COUNTIFS($A:$A,$A2,$B:$B,$B2,$C:$C,$C2,$D:$D,$D2)>1

另解=SUMPRODUCT(N(MMULT(COLUMN(A:H)^0,N($A$2:$D$9=$A2:$D2))>1))=4