• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2318
  • Last Modified:

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?
0
lora2014
Asked:
lora2014
1 Solution
 
Jerry PaladinoCommented:
Try applying the formatting when all filters / slicers are in their unfiltered status.  You may have to remove what you have first and then reapply once everything is unfiltered.  I have had similar issues with regular formatting on pivot tables and found this method works for me.
0
 
jkasavanCommented:
Or...have the conditional formatting rule apply to ALL of column E ($E:$E).
0
 
lora2014Author Commented:
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.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now