Pivot table conditional formatting

S

SD

I have a relatively large pivot table. Can I do a conditional
formatting of cells so that if cell font changes color based on
conditions

e.g. I have a pivot table that lists Monthly sales by product

Report is like this
Page level -Region,Promotion

Horizontal ---> Months

Vertical --> Products

If I want to compare the latest months sales over last month if more
then make it green if less make it red, If I change the pivot
condition at the top it should automatically adjust the colors

Also can I compare the pivot table cells to Mean, Median etc for a
quarter, year

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Excel does not accept text format! 0
Pivot Table Comparison 0
Conditional Formatting with VBA 4
Highlight cell if criteria met 0
Automatically Update a Pivot Table Field Used as Column / Row 2
Conditional formatting dates 3
recognizing conditional formatting with VBA 3

Top