This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
@jrgo I'm working on something similar, but having trouble with the formula, which I want to only apply when WHSE equals NC1.
I'm using this expression, but it's only changing the text color. I need it to change the background or fill color instead.
IF [OnHand]> 10 THEN "color:green" ELSE "color:null" ENDIF
What am I missing?
Ideally, I'm trying to get to the point where I can create an expression to consider 2 fields (ie, if SKU = 16 and OnHand>=10 then green background AND if SKU = 16 and OnHand<10 then red background. Thoughts?
Thanks, this worked. But because of the "null", now the null is overriding multiple rules. Basically, I am trying to get cells to color red when values are below 5, orange if between 5 and 10, and green if greater than 10. I used your expression to create the red and green rules, but only one is making an appearance.
In this image, I have both rules set up. But it's only displaying the rule falling within the red parameters.