有条件格式的方程无效

发布于 2025-01-24 14:27:09 字数 420 浏览 0 评论 0原文

我的公式在单元格中效果很好，但是当我将其插入有条件的格式时被标记为无效。但是，方程的逻辑正是我所需要的。公式如下：

= if（regexMatch（vlookup（vlookup（h2，dials_rng”），列（deals！$ g $ 1）-column（deals！$ a $ a $ 1）+1，0），“喜欢“），q2＆gt; = vlookup（h2，间接（“ deals_rng”），列（deals！$ f $ 1）-column（deals！$ a $ 1）+1，0），r2＆gt; = vlookup（h2，indirect（h2，indirect）（ deals_rng”），列（deals！$ f $ 1）-column（deals！$ a $ 1）+1，0））

我必须更改什么才能使等式有效地有条件格式化？

感谢我能得到的任何帮助！

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

甜宝宝 2025-01-31 14:27:09

绿色：

=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)))

green:

=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)))

red:

=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)))