|
条件格式
选择G3:K20
公式=ISNUMBER(MATCH(TEXT($G3,"yyyy.mm.dd")&TEXT($H3,"00000")&TEXT($I3,"000.00")&TEXT($J3,"000.00")&TEXT($K3,"000.00"),$A$3:$A$30&TEXT($B$3:$B$30,"00000")&TEXT($C$3:$C$30,"000.00")&TEXT($D$3:$D$30,"000.00")&TEXT($E$3:$E$30,"000.00"),))
选择颜色 |
|