Multiple background colours

[#1]

Hi,

I want to use multiple backgrounds, just like this:

Help me please!

Thanks!

[MayilVahanan]

Hi

You can use background color in the expression tab by clicking the '+'  sign in it.

or

right click the chart, you can see custom format cell option.. You can use that.

[#3]

But i want it automatically, calculated on the value of the table

[MayilVahanan]

HI

You can use background color in the expression tab by clicking the '+'  sign in it.

In that you can give the expression and color based on your requirement. For ex:

=if(Sum(Sales) <= 500, red(), green())