Slicer by Cell Color/Conditional Formatting

[ducktapeonmydesk]

I have conditional formatting on a table that change cells' colors based on value. I know I can filter by cell color, but is there a way to use a slicer to filter by cell color? e.g. in my 'Sales' slicer, select stores that have red conditional formatting applied.

 

[Oaktree]

Not directly. Instead, add a new field to your data that will tell you the color according to the same criteria you have in your conditional formatting.

e.g. =IF([first criterion's test = true], "Red",IF([second criterion's test = true],"Blue",....

Then, have your slicer reference that new field, and you can slice for just the "Red" ones or similar.