Condition Color Coding

[rxp03570]

Hi All,

Here I'm trying to achieve color coding based on three conditions. Have the fields Sum(Actual) & Sum(Forecast). Need to color code text in Sum(Actual) based on the below conditions:

If, Actual   +/- 10  of the Forecast = Green

    Actual   +/- 11  to 25  of the Forecast   = Blue

    Actual   +/- 26  and greater of the Forecast = Red.

Thanks for your help.

[boorgura · Accepted solution]

You will have to give the expression in either the Text Color or Background color depending on your requirement.

IF(fabs(sum(actual)-sum(forecast)) <= 10, green(),

     IF(fabs(sum(actual)-sum(forecast)) <= 25, blue(),

     red()))

[sergio0592]

As background color, try with :

=if(sum(Actual)-sum(Forecast) <=10 and sum(Actual)-sum(Forecast)>=-10 , green(), if(sum(Actual)-sum(Forecast)<=25 and sum(Actual)-sum(Forecast)>=-25, blue(),red()))

[rxp03570]

Works Perfectly, Thanks!!!

[rxp03570]

This one works as well, Thanks!!!