ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I stop an pivot report from losing conditional formatting (https://www.excelbanter.com/excel-discussion-misc-queries/58015-how-do-i-stop-pivot-report-losing-conditional-formatting.html)

Deb

How do I stop an pivot report from losing conditional formatting
 
I have a pivot table that needs updated weekly and everytime I refresh the
report it loses its formatting and I start over. This report conditional
formatting needed reflects changes in color when collections drop for 3
consecutive months in a row. example

Oct Nov Dec Jan
451 390 280 180 the report needs to change color first
month drop yellow, second orange and third and additional months that have
dropped turn red. Any assistance on how to handle conditional formatting and
prevent it from losing when refreshed will be appreciated.


All times are GMT +1. The time now is 12:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com