ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pivot table conditional formatting (https://www.excelbanter.com/excel-programming/278336-pivot-table-conditional-formatting.html)

SD[_4_]

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