我有一個公式可以在單元格中正常作業，但是當我將其插入條件格式時被標記為無效；然而，等式的邏輯正是我所需要的。公式如下：
=IF(REGEXMATCH(VLOOKUP(H2, INDIRECT("DEALS_RNG"), COLUMN(DEALS!$G$1)-COLUMN(DEALS!$A$1) 1, 0), "Likes"), Q2>=VLOOKUP(H2, INDIRECT("DEALS_RNG"), COLUMN(DEALS!$F$1)-COLUMN(DEALS!$A$1) 1, 0), R2>=VLOOKUP(H2, INDIRECT("DEALS_RNG"), COLUMN(DEALS!$F$1)-COLUMN(DEALS!$A$1) 1, 0))
為了使等式對條件格式有效，我必須更改什么？
感謝我能得到的任何幫助！
uj5u.com熱心網友回復：
綠色：
=IF(REGEXMATCH(VLOOKUP(H2, INDIRECT("DEALS_RNG"), COLUMN(INDIRECT("DEALS!G1"))-COLUMN(INDIRECT("DEALS!A1")) 1, 0), "Likes"),
NOT(Q2>=VLOOKUP(H2, INDIRECT("DEALS_RNG"), COLUMN(INDIRECT("DEALS!F1"))-COLUMN(INDIRECT("DEALS!A1")) 1, 0)),
NOT(R2>=VLOOKUP(H2, INDIRECT("DEALS_RNG"), COLUMN(INDIRECT("DEALS!F1"))-COLUMN(INDIRECT("DEALS!A1")) 1, 0)))
紅色的：
=IF(REGEXMATCH(VLOOKUP(H2, INDIRECT("DEALS_RNG"), COLUMN(INDIRECT("DEALS!G1"))-COLUMN(INDIRECT("DEALS!A1")) 1, 0), "Likes"),
(Q2>=VLOOKUP(H2, INDIRECT("DEALS_RNG"), COLUMN(INDIRECT("DEALS!F1"))-COLUMN(INDIRECT("DEALS!A1")) 1, 0)),
(R2>=VLOOKUP(H2, INDIRECT("DEALS_RNG"), COLUMN(INDIRECT("DEALS!F1"))-COLUMN(INDIRECT("DEALS!A1")) 1, 0)))
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/466262.html