Autofilter Arrow Colours

[AndyW]

Excel 2003
I will be spending a lot of time filtering a lot of spreadsheets with
between 50 and 100 columns.
I find the default colours used in the drop-down arrow on the autofilter too
close to differentiate. The black for unselected and the blue for selected
are too close for me to differentiate and it will make the task hard and
more tedious than it should be. I would like to set the arrow for a filtered
column to something obvious like bright yellow or red.
I cannot find a way to do this. Is there a way to change the default
colours?

Many thanks

Andy

 

[Dave Peterson]

It's not possible to change this.

Excel 2003
I will be spending a lot of time filtering a lot of spreadsheets with
between 50 and 100 columns.
I find the default colours used in the drop-down arrow on the autofilter too
close to differentiate. The black for unselected and the blue for selected
are too close for me to differentiate and it will make the task hard and
more tedious than it should be. I would like to set the arrow for a filtered
column to something obvious like bright yellow or red.
I cannot find a way to do this. Is there a way to change the default
colours?

Many thanks

Andy

 

[Gord Dibben]

Debra Dalgleish has a sample workbook with code to color the heading in a
filtered column.

http://www.contextures.on.ca/excelfiles.html#Filter

FL0014 - Colour Filter Headings -- Event code colours the filtered column
headings, when an AutoFilter is applied. FilterColour.zip 9 kb 15-Apr-05



Gord Dibben MS Excel MVP

 

[AndyW]

Debra Dalgleish has a sample workbook with code to color the heading in a
filtered column.

http://www.contextures.on.ca/excelfiles.html#Filter

FL0014 - Colour Filter Headings -- Event code colours the filtered column
headings, when an AutoFilter is applied. FilterColour.zip 9 kb 15-Apr-05

Thanks Gordon. Not quite what I was looking for but interesting.

Andy