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.