April 23, 2015
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
July 16, 2010
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
April 23, 2015
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
1 Guest(s)