color coding for table

[yogitamehta10]

HI ALL,

i was writing this expression for color coding  i'm doing something wrong ,value is the Expression Label and my values are in %

if(value<-5,RED(),
If(value<=-5 and TS% <=-2.5 ,RGB(255,99,71),
if(value<=-2.5 and value<0.5,RGB(205,92,92),
if(value<= -0.5 and value<0.5,
RGB(255,255,255),
if(value <= 0.5 and value <2.5,RGB(154,205,50),
if(value <= 2.5 and value <5,RGB(127,255,0),
if(value > 5,RGB(0,128,0))))))))

TIA

[sunny_talwar]

What is wrong with it?

[yogitamehta10]

it seems to be some issue

[sunny_talwar]

Hahaha what is the issue Yogita?

[yogitamehta10]

I meant is my syntax right ?because it  shows  error in expression.

[sunny_talwar]

Don't see an issue with the syntax, not sure if TS% is needed or not, but that is the only thing which seems little out of line...