Dynamic formatting of pivot table

[excelsucker]

I have a pivot table that has periodically updating data in it. This data makes the pivot table add and delete rows of data making the table longer and shorter. I currently have conditional formatting that applies to the table, however, when the table is made longer or shorter, it breaks the formatting. How can I dynamically apply this formatting to the table, depending on how long or short the table is?

[AliGW]

Welcome to the forum.

We'd need to see the nature of your pivot table.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.