Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to color code the expression field (background color) based on the value range:
example:
if the cell value is >2 its green
if the cell value falls between = 2 and =1 its yellow
if the cell value falls between >1 and =-1 its red
Can someone help me with the syntax for the condition ?
Regards,
H
May be this:
If(Expression < 1, Red(), If(Expression < 2, Yellow(), Green())
maybe (I used the sum(Amount), change according to your expression)
if(sum(Amount2)>2, Green(),
if(sum(Amount2)=2 or sum(Amount2)=1, Yellow(),
if(sum(Amount2)>-1 and sum(Amount2)<1, Red(),
Black()
)))