+ Reply to Thread
Results 1 to 2 of 2

Can a pivot table function like data filter?

  1. #1
    Registered User
    Join Date
    07-18-2005
    Posts
    4

    Can a pivot table function like data filter?

    My question is related to the feature that a data filter offers whereby the
    drop down arrow changes color (to royal blue) once an option in the filter is
    selected.

    I have a very detailed pivot table. When an option is selected it
    is difficult to visually see which option(s) was chosen. I was wondering if
    there is any way to make the drop down arrow in the pivot table function
    similar to that of the drop down arrow in the data filter, i.e., have the
    color of the drop down arrow and/or option selected change color so that it
    stands out on the spreadsheet. This will enable the user to quickly determine
    which option(s) needs to be reset.

  2. #2
    Registered User
    Join Date
    07-18-2005
    Posts
    4

    Thumbs up Found the answer!

    Just wanted to let everyone know that I found the answer. It is to use conditional formatting. This will enable the user to view the selected option (though not the drop-down arrow) in a color/format of my choice. I hope this answer helps others who are looking for similar solutions!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1