autofilter indicator change

[cbray]

When a column is selected and an autofilter is applied the carrot indicator
at the top of the column changes very slightly (the triangle goes from black
to blue) . Does anyone have a way of making it stand out so I know which
column has an auto filter applied? Having the whole thing go yellow or red
would help.

 

[Gord Dibben]

Debra Dalgleish has a sample workbook with event code to color the headers
with AF enabled.

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

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

BTW.............what is a "carrot" indicator?

Could that be "caret" (^) ?


Gord Dibben MS Excel MVP

 

[cbray]

Thanks. That does do what I want. I wasn't quite certain what to call the
pull down arrows at the top of the columns. It isn't an arrow one draws -
which is what help pointed me to. It isn't really a caret, so I went for
carrot figuring someone would figure me out.

Thanks.. That code seems to do what I want, now I just have to apply it.

Carolyn

 

[Gord Dibben]

Thanks for the feedback.

I call those indicator thingies "arrows".

I believe most users have settled on that.


Gord Dibben MS Excel MVP

 

[TommyB]

Hello... this worked great for my application also, but it won't work with
the worksheet protected. Any thoughts?

 

[Roger Govier]

see response to later posting