Hi All
I would like to know if it is possible to format a pivot table by category?
I have a table which has data for Hours worked, and it is broken down by Paid and Unpaid with a number of different elements possible under each "Heading".
I would like to use conditional formatting to make anything under the Heading "Paid" Green, and anything under the heading "unpaid" Orange.
I have only been able to get the actual Heading Word to change, not any data that falls within that category.
Any help would be greatly appreciated.
Bookmarks