Conditional formatting in Straight table

[#1]

Hi All,

I need the expression to change the cell background color according.

if its 0 - 40% is Red

41% - 70% is Yellow

71% - 100% is Green

Like below.

Thankyou all.

[Anonymous]

expand + sign of expression put if condition code in color option

[maxgro · Accepted solution]

try with background color

if(yourexpression >0 and yourexpression <=0.4, rgb(255,0,0),

if(yourexpression >0.4 and yourexpression <=0.7, rgb(255,255,0),

if(yourexpression >0.7 and yourexpression <=1, rgb(0,255,0),

rgb(?,?,?)

)))

[sunny_talwar]

Is this what you are trying to do? PFA

Best,

S

[#5]

Yes Sunindia am trying for that

[sunny_talwar]

Have you looked at the attached qvw file? It will help you understand what needs to be done to create the same view.

Best,

S

[#7]

Thank you i got it