EXCEL迷

(先)格式化 A1:J10=COUNTIF($A1:$J1,$L$2)+COUNTIF(A$1:A$10,$L$2)+(SUMPRODUCT(N($A$1:$J$10=$L$2)*COLUMN($A:$J))+SUMPRODUCT(N($A$1:$J$10=$L$2)*ROW($1:$10))=COLUMN(A1)+ROW(A1))+(SUMPRODUCT(N($A$1:$J$10=$L$2)*COLUMN($A:$J))-SUMPRODUCT(N($A$1:$J$10=$L$2)*ROW($1:$10))=COLUMN(A1)-ROW(A1))

格式化A1:J10=A1=$L$2