You are reading a single comment by @dubtap and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@dubtap
Do you have the pivot table on the same sheet as the source data or on a separate tab?
Some of your conditional formatting might now be referencing pivot table cells if you have used absolute cell references and then inserted rows/columns to insert the pivot.
Always easier to check if you separate the original source data and the views of the data (here's a tab with conditional formatting applied, here's the tab with the pivot table) into separate tabs.