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.

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

On Tue, 7 Oct 2008 09:48:01 -0700, cbray
wrote:

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.

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" wrote:

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

On Tue, 7 Oct 2008 09:48:01 -0700, cbray
wrote:

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.

Thanks for the feedback.

I call those indicator thingies "arrows".

I believe most users have settled on that.


Gord Dibben MS Excel MVP

On Tue, 7 Oct 2008 10:45:01 -0700, cbray
wrote:

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" wrote:

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

On Tue, 7 Oct 2008 09:48:01 -0700, cbray
wrote:

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.

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


"Gord Dibben" wrote:

Thanks for the feedback.

I call those indicator thingies "arrows".

I believe most users have settled on that.


Gord Dibben MS Excel MVP

On Tue, 7 Oct 2008 10:45:01 -0700, cbray
wrote:

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" wrote:

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

On Tue, 7 Oct 2008 09:48:01 -0700, cbray
wrote:

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.

see response to later posting

--
Regards
Roger Govier

"TommyB" wrote in message
...
Hello... this worked great for my application also, but it won't work with
the worksheet protected. Any thoughts?
--
TommyB


"Gord Dibben" wrote:

Thanks for the feedback.

I call those indicator thingies "arrows".

I believe most users have settled on that.


Gord Dibben MS Excel MVP

On Tue, 7 Oct 2008 10:45:01 -0700, cbray

wrote:

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" wrote:

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

On Tue, 7 Oct 2008 09:48:01 -0700, cbray

wrote:

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.