Background color pivot table based on column total

[vivekraghu25]

Hi all

I've been struggling with this and hoping I could get some help. I have a pivot table with a field called Spec in the Row. The column area has 2 fields, region and area. I have turned on the Show totals toggle for the region column and would like to have all background color based on that totals. 

As seen in the attached, I have turned on the "Show totals" toggle on the region column and can see that it is 1.46 for the first item in the row. I'd like the background color of the values in that row to be red if greater than 1.46 and green if lesser. And likewise, apply this for all rows.

Appreciate any help with this.

[Antoine04]

Hello,

Is that what you want to do ?

If yes, here is the formula you need to write : 

If(ColumnNo()=0,Blue(),
    If(Avg(Marge)>Avg(Total <Mois> Marge),Green(),LightRed()))

Regards,

Antoine

[vivekraghu25]

Almost. But not exactly. To give an example, If the values in the first row are less than 9,14 then green, else red. Similarly for all rows. 

[Antoine04]

So, like this ?

Or all the cells compared to 9.14 ?

Regards

Antoine