varying background color in straight table

[#1]

Hi I have a straight table and i want to show the growth% in it where the background color has to vary according to the growth%.For example if the growth% is -25% then background will be dark red in color whereas if the growth% is -2% then background will be light red in color.

plz help

I

[m_woolf · Accepted solution]

If your Growth% field is X:

=ARBG(-1*X*1000,255,0,0)     for the background color of the expression for the chart

[#3]

thanks ,it worked.