Filtered Columns - change colour of icon
When a filter is applied in a header row, the filtered column(s) gets a "Funnel" icon to indicate that it has been filtered. In a row where multiple filters have been applied, if, in addition to having the funnel icon, the "filtered" icons came in a different colour - say a limited choice of colours for the user to pick from - then that would make the filtered columns easier to spot. For a user looking for the first time at a file and wanting to find what columns have been filtered, having the "filtered" icons in a different colour from the rest of the "drop-down" like icons that are attached to the header row would enable the user to more easily spot the filtered columns. Just saying.
Thanks for the great suggestion to make filtered columns more visible. Unfortunately we will not be able to address this in the near future. We will update this item and re-open voting if our plans change.
Don't just change the colour of the icon change the colour of the whole column box, ie the C or AV.
Don't just change the colour of the icon change the colour of the whole column heading box, i.e. the C or AV.
I have wanted this for a long time now. Thought MS would have done this enhancement by now. I work with excel every day and have a lot of sheets with many many columns. It is difficult to see and know which columns are filtered. Many times I resort to toggling the filters off then back on in order to reset them all. Then I go back and filter what I want.
"We seem to be made to suffer. It's our lot in life."
Tobias Wittenburg commented
Great idea! I know a lot of People who would benefit from this!
Jonathan Dart commented
Colorize the chevron above a filtered column. It would be helpful if the filter box / icon at the top of a column changed color when a filter has been applied. When dealing with many columns, it would help to visually identify which data has been filtered.