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

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 he

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

Under Filters, look for 'Colour Filter Headings'


Nuno Jácome wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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:

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 he

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

Under Filters, look for 'Colour Filter Headings'


Nuno Jácome wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

Nuno Jácome wrote:
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:


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 he

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

Under Filters, look for 'Colour Filter Headings'


Nuno Jácome wrote:

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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





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