ExcelBanter - How to lock conditional formatting in pivot tables?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to lock conditional formatting in pivot tables? (https://www.excelbanter.com/excel-discussion-misc-queries/200748-how-lock-conditional-formatting-pivot-tables.html)

terri.hirsch[_2_]

How to lock conditional formatting in pivot tables?

I've used pivot table options to set "preserve formatting on refresh", which
it does with the exception of conditional formats.

All times are GMT +1. The time now is 06:59 PM.