Pivot table - looses conditional formatting when slicing
Posted on 2014-01-21
I have a pivot table, where column E is color coded, into 4 different colors, depending on the range of the value. I have a slicer to filter the table by the value in a different column. Upon doing any of this filtering/slicing, the color coding disappears in column E. However, what is strange is the rules are still apparent when I check my conditional formatting.
I had no trouble with this before with another pivot table I had. Could it be that I need to conditional format before creating the slicer or vice versa? Are there any other solutions, to make it so my color formatting does not disappear?