Forum Discussion
Dynamic conditional formatting
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?
1 Reply
biggums While you are setting up the CF rule you should be able to choose to what the rule should apply. Make sure you pick something other than "Selected cells".
