判斷 6行全相同 (10600)

E2{=AND(RIGHT(SMALL(CODE(A1:C6)+ROW(1:6)*1000,ROW(1:6)*3-3+{1,2,3}),3)-SMALL(CODE(A1:C1),{1,2,3})=0)

條件格式 (儲存後 下載重設)A2:C6{=COUNT(MATCH(COLUMN($A:$C),MATCH($A2:$C2,$A$1:$C$1,),))=3

F2:F6輔助 無須重設 {=COUNT(MATCH(COLUMN($A:$C),MATCH($A2:$C2,$A$1:$C$1,),))=4

條件格式A2:C6=$F2-1