Dynamic Color only for Column not Sum

[psk180590]

Hello All,

I would like to have Color in my Pivot Table when the number is greater then a particular value. But, the Color of the column Total must remain default.

Example:

Sales
30
40
50
10
12
14
16
89
83
Total: 344

Here, i would like to Color all the Columns above 40 with Yellow but, the Total  must remain the same.

Thanks!!

[stabben23 · Accepted solution]

this could help, =if(RowNo()<>0 and ColumnNo()<>0 and Sum(Quantity) <> Sum(TOTAL Quantity) and Dimensionality() =3 and sum(Quantity) > 50, Yellow())