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.