Forum Discussion
Using Slicers to filter by color rather than value
Is there a way to filter by color rather than value in a slicer? I have applied conditional formatting to a column of cost numbers that gives a color to each cell based on a range of numbers. E.g. $0-$125 is light green, $126-250 is medium green, etc... I would like the slicer to show just the 3 colors representing the cost ranges. Otherwise I will have 20 different buttons on my slicer.
1 Reply
You might add a calculated column to the source data
=IF(cost<=125, "$0-$125", IF(cost<=250, "$126-$250", "$251 and over"))
Add this to your pivot table and use it in a slicer.
