how to change the background color of total in pivot table

[louise119]

Hi,
I use pivot table and I wanna change the background color of total value.
When the total value ='-', the background color doesn't change the color  I set.

Does someone know how to solve this problem?

[RafaelBarrios]

hi @louise119 

you can't as '-' is not a value, but null or empty

what you can do is telling your formula to do something when total is null, like returning 0 using a rangesum or something similar.

hope it helps

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!