ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is it possible to change the blue colour of an activated Auto Filter button? (https://www.excelbanter.com/excel-discussion-misc-queries/14858-possible-change-blue-colour-activated-auto-filter-button.html)

Marcel Wilmink via OfficeKB.com

Is it possible to change the blue colour of an activated Auto Filter button?
 
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?

--
Message posted via http://www.officekb.com

Debra Dalgleish

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'


Marcel Wilmink via OfficeKB.com wrote:
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?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 03:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com