Bar chart conditional format background color with full accumulation

[guyvermeiren]

Hello,

I have a bar chart where there are 3 values by month. See picture. Actual and Plan are values by Month ( no accumulation) and Var has "Full accumulation". I would like to apply a conditional format to Var (Green when >0 an Red when <0).

I tried with "Background color" (=if(Var <0,Red(),Green()) but this always applies to the Monthvalue and not to the acccumulated value.

Is there are solution for this ?

Thanks,

Guy

[#2]

You can maybe try this in your background color expression

if(rangesum(above(Expression,0,Rowno()))>0, Green(),Red())