![]() |
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