How to Apply Conditional Formatting with Excel Slicers

How to Apply Conditional Formatting with Excel Slicers

In this video I'll show you how to apply conditional formatting with Excel slicers. Excel slicers are a handy and easy to use filtering system that Excel has built in but you can use it to actually apply conditional formatting.

For the first step you need to setup your data and then create a pivot table out of your data set. Find the field that you'd like to add conditional formatting based on. Once you've done that drag it into the row section of the pivot table. Go to the design tab of the pivot table tools and then select insert slicer. Select the field that you've added to the row section of your pivot table. Cut and past the filter onto the same spreadsheet/worksheet as your data set.

Click and select one of the Excel slicer selection options. Once you've done that, you can then head to conditional formatting from the home tab and create a formatting option using the formula option. In the formula bar you'll type =the cell on the data set of your first row and then = to the first cell of your pivot table. Now you're going to copy and paste the conditional formatting that you applied to the first row of your data set.

You can now use the Excel slicer to change and highlight the rows based on a specific value.

Other Resources and links

Introduction to Slicers – What are they, how to use them, tips, advanced techniques & interactive reports using Excel Slicers

Getting Fancy with your Excel Slicers

Excel Slicer Trick

Use Excel Slicer Selection in Formulas

Excel
8 tips and tricks you should know for Excel 2016 for Mac

Another way to get and use slicer values in formulas

Interactive Excel Dashboard Tips Using Slicers and Pivot Charts

Apply Conditional Formatting using Slicers

Conditional Formatting Controlled via Slicers!

Excel Pivot Table CONDITIONAL FORMATTING: Excel 2013, 2010 & 2007

Pivot table - looses conditional formatting when slicing

Conditional Formatting via Slicers, Part Two

Slicers in excel

How to use a slicer for multiple pivot tables

[jbgonzalez]

Thank you so much for your videos. I have learn a lot with them.

[simdog]

Thanks, very interesting, I am not really experienced with VBA but i would be interested how to filter the dataset as you describe here. In fact it is the first thing that popped into my head when i saw this

[vineetpandita]

If you use a table intead of pivot you can get the rows filtered by slicer

[ahmedfahmi]

Hi bro, I've a slicer with regions names and there are a maps for that regions,
so i need to link each region with its corresponding map as follows:

once i choose a specific region name in the slicer the corresponding map color changed to red and other regions remains blue.

I hope you help me.