I have a macro set up that creates a very generic looking pivot table, and I would like it to be able to automatically highlight the subtotal rows in yellow. Any ideas out there on how this is done. I am guessing that there is a simple solution to this, but I am having a brain fart right now....