Jump to content
Microsoft Windows Bulletin Board

Recommended Posts

Posted

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. 

View the full article

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...