Is it possible to change the blue colour of an activated Auto Filter button?

  • Thread starter Thread starter Marcel Wilmink via OfficeKB.com
  • Start date Start date
M

Marcel Wilmink via OfficeKB.com

When Auto Filtering is on and one of the filters is active, the button's
colour is changed to blue. Often, I find it difficult to distinct this blue
colour with the black colour of an inactive filter.

Can the colour of this blue Auto Filter button be changed?
 
AFAIK, no one has found a way to change the autofilter arrow colour.

If you can use programming, there's a sample file that uses a User
Defined Function and conditional formatting to colour the heading cells:

http://www.contextures.com/excelfiles.html

under the heading 'Filters' look for 'Highlight AutoFilter Headings'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top