I'm trying to create some kind of VB routine to automatically highlight any
cells in my header row which are filtering my data. The default in Excel is
to color the arrow in the drop-down for your autofilter criteria blue, but
the arrow is so small it's difficult to tell which columns are filtered. If
there was a way to color the entire cell bright yellow or blue or something,
then it would be easy to see which columns are filtered. I deal with some
rather large spreadsheets and sometimes have 6 or 7 columns filtered and it's
easy to lose track of which columns are filtered and which aren't.

There's a sample file here in which the heading cell is coloured if a
filter is applied to that field:

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

Under Filters, look for 'Colour Filter Headings'

DBro wrote:
I'm trying to create some kind of VB routine to automatically highlight any
cells in my header row which are filtering my data. The default in Excel is
to color the arrow in the drop-down for your autofilter criteria blue, but
the arrow is so small it's difficult to tell which columns are filtered. If
there was a way to color the entire cell bright yellow or blue or something,
then it would be easy to see which columns are filtered. I deal with some
rather large spreadsheets and sometimes have 6 or 7 columns filtered and it's
easy to lose track of which columns are filtered and which aren't.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html