Filter icon

[Guest]

I have automatic filter on several columns, when I use the filter on one of
them the icon stays on blue intead of black anounce the filter column. The
problem is I could't see it very well. Could I change the filter icon
propreties ?

Thanks

 

[Debra Dalgleish]

No, you can't change the colour of the filter arrow.

If you can use programming, you can colour the heading cell of the
filtered column. There's a sample here:

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

Under Filters, look for 'Colour Filter Headings'

 

[Guest]

Thanks Debra

Excelent

One more question:
In my project the heading cells are format with interior.colorindex=4.
When I use your programing I get color4 when active the filter and then white.
Could I have color 4 and 6 (filter on) and 4 again after filter off ?

"Debra Dalgleish" escreveu:

 

[Debra Dalgleish]

You're welcome! In the code you can replace xlNone with 4 and you'll get
the heading colour that you want.