Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
this could help, =if(RowNo()<>0 and ColumnNo()<>0 and Sum(Quantity) <> Sum(TOTAL Quantity) and Dimensionality() =3 and sum(Quantity) > 50, Yellow())