software

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

www.contextures.com/excelfiles.html

Under Filters, look for 'Colour Filter Headings'Nuno Jácome wrote:
gt; I have automatic filter on several columns, when I use the filter on one of
gt; them the icon stays on blue intead of black anounce the filter column. The
gt; problem is I could't see it very well. Could I change the filter icon
gt; propreties ?
gt;
gt; Thanks--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlThanks 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 ?

quot;Debra Dalgleishquot; escreveu:

gt; No, you can't change the colour of the filter arrow.
gt;
gt; If you can use programming, you can colour the heading cell of the
gt; filtered column. There's a sample he
gt;
gt; www.contextures.com/excelfiles.html
gt;
gt; Under Filters, look for 'Colour Filter Headings'
gt;
gt;
gt; Nuno Jácome wrote:
gt; gt; I have automatic filter on several columns, when I use the filter on one of
gt; gt; them the icon stays on blue intead of black anounce the filter column. The
gt; gt; problem is I could't see it very well. Could I change the filter icon
gt; gt; propreties ?
gt; gt;
gt; gt; Thanks
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;

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:
gt; Thanks Debra
gt;
gt; Excelent
gt;
gt; One more question:
gt; In my project the heading cells are format with interior.colorindex=4.
gt; When I use your programing I get color4 when active the filter and then white.
gt; Could I have color 4 and 6 (filter on) and 4 again after filter off ?
gt;
gt; quot;Debra Dalgleishquot; escreveu:
gt;
gt;
gt;gt;No, you can't change the colour of the filter arrow.
gt;gt;
gt;gt;If you can use programming, you can colour the heading cell of the
gt;gt;filtered column. There's a sample he
gt;gt;
gt;gt; www.contextures.com/excelfiles.html
gt;gt;
gt;gt;Under Filters, look for 'Colour Filter Headings'
gt;gt;
gt;gt;
gt;gt;Nuno Jácome wrote:
gt;gt;
gt;gt;gt;I have automatic filter on several columns, when I use the filter on one of
gt;gt;gt;them the icon stays on blue intead of black anounce the filter column. The
gt;gt;gt;problem is I could't see it very well. Could I change the filter icon
gt;gt;gt;propreties ?
gt;gt;gt;
gt;gt;gt;Thanks
gt;gt;
gt;gt;
gt;gt;--
gt;gt;Debra Dalgleish
gt;gt;Excel FAQ, Tips amp; Book List
gt;gt;www.contextures.com/tiptech.html
gt;gt;
gt;gt;
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html