color coding as per grouping on bar chart

[deeavhad]

Hi,

I have used following expression for color coding of bars in bar chart but the 1st and last if condition is not working

if([New Aging]<=1,LightGreen(),if([New Aging]=2,LightGreen(), if([New Aging]=3,Green() , if([New Aging]=4,RGB(255,191,0),if([New Aging]=5,lightred(), if([New Aging]>5, Red()))))))

in above bar chart I want 1st grey bar as per 1st if condition to be lightgreen like bar 2 and remaining 2 grey bars need to be dark red as per last if condition

Please guide me

[anat]

if([New Aging]<=2,LightGreen(),
if([New Aging]=3,Green() ,
if([New Aging]=4,RGB(255,191,0),
if([New Aging]=5,lightred(),
if([New Aging]>=6, Red()
)))))

[deeavhad]

still the result is same, no change in color code