Can soemone help me set negitive numbers to red within power pivot tables. I have defined the cells to do so, but the table looses the formating with each pivot change or update.
Looks like it is the same as regular pivot tables when I asked this question once before. Can't believe I forgot this! HA
Go to the cell in the Pivot that is listed as Sum of ### or Count of ### it is usually the first cell in the upper left portion of the pivot ..right click and you will see an option for Value Field Settings select this and then you will see a button at bottom left hand corner that states Number Format select the Red Negative from the Number Format and it will resolve your problem.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
