![]() |
Pivot table conditional formatting
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 |
All times are GMT +1. The time now is 12:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com