'Equation invalid in conditional formatting
I have a formula that works fine in cells but is marked as invalid when I plug it into conditional formatting; the logic of the equation however is exactly what I need. The formula is as follows:
=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))
What must I change in order to make the equation valid for conditional formatting?
Appreciate any help I can get with this!
Solution 1:[1]
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)))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |