格式化三條件 (14194)

B2:B12格式化=SUMPRODUCT(MMULT(N(B2:C2=L$2:M$5),ROW($1:$2))*COUNTIF(D2,"*"&N$2:N$5&"*"))=1

另解=SUMPRODUCT(MMULT(N(B2:C2=L$2:M$5),ROW($1:$2))*COUNTIF(D2,"*"&N$2:N$5&"*"))=1

另解=SUMPRODUCT(COUNTIFS(B2,L$2:L$5,C2,"<>"&M$2:M$5,D2,"*"&N$2:N$5&"*"))