Is there a way to add a background color to your pivot table so that say you total sums are marked in yellow or red and your profits are marked in a different color? As in the cells of the pivot table. Any help would be appreciated. Sorry just figured it out myself didnt realize it was that simple
Last edited by Just as lost as you; 05-24-2013 at 03:36 PM. Reason: Brain started working
Is this solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Yes I did solve the issue myself just had to open my eyes as it were. I used auto fill after selecting the cells I wanted to and then chose the color I wanted. Side not however if you choose a dark color make sure to change your font color so that it is visible
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks