lora2014
asked on
Pivot table - looses conditional formatting when slicing
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or...have the conditional formatting rule apply to ALL of column E ($E:$E).
ASKER
The key item here was starting from scratch. Basically, I started all over again, and it worked. I designated the column by it's field name instead, not just the column.