Search code examples
excelpivot-tableconditional-formattingslicers

Using conditional formatting on Excel slicers

I have intermediate excel skills and am relatively new to pivot charts and slicers. I have made a pivot chart out of production-related data. Next to the chart is a slicer that displays all the different products in production. Basically, whenever the user clicks on one of the products in the slicer, it displays a bar graph mixed with a line graph. If the bars are exceeding the line, then the product is considered "critical" (it is exceeding production capacity). I want to use conditional formatting (or another method, preferably not a macro) to highlight the products on the slicer in red that are critical.

Thanks in advance for your help.

Solution

  • You can't conditionally format Slicer Items. Instead, your best bet is to use a second PivotTable that only shows the critical products in it.