Hi everyone, I have a workbook with multiple slicers and conditional formatting rules. I have been working with this file for months an have had no issues with the conditional formatting rules being retained when the pivot table is refreshed - until recently. Not sure what I have done to cause the issue but now when I refresh the table by changing a slicer selection the conditional formatting is removed. I have the "preserve cell formatting on update" checked, I can use the format painter to apply the conditional format rules on all cells and it displays correctly, but when I change a slicer variable the conditional formatting is removed.
Could you possibly give some suggestions how to fix this?
Alan
Hi Alan,
When using conditional formatting with PivotTables you need to set it up in a particular way which is described in this tutorial on conditional formatting in PivotTables
Hope that helps. If you're still having problems, please come back and share the file so we can see the issue.
Mynda
Hi Mynda,
Many thanks and of course the article was very helpful - I have almost got it back to the previous iteration. The file is very large so I have not posted it here but I am hoping the screen shot might help with my final dilemma. You can see I have most of the rules applied to the field references but the last one with the orange fill format keeps defaulting to a cell range - any idea what I am doing wrong to generate that?
Alan
Hi Alan,
Hard to say as I can't see the row and column labels in the screenshot to reference it to the conditional formatting rule. Perhaps you have selected cells that are outside of the PivotTable values area in the applies to range?
Mynda
Hi Mynda,
Sorry for the delay replying. I seem to have got it working though to be honest I sort of stumbled through it rather than having a "light bulb" moment. I applied the rule to each column individually and it is working as intended. Thanks for the help!
Alan
Great to hear, Alan!
