How can I change the colors used for the drop downs in autofilter?

[wotgoesup]

I have a major spreadsheet with over 60 cols of data. I have a freeze panes set at cell D3, and users scroll across, often filtering on 4 or more cols. They often zoom to 75%, and hide some cols to view more of what they want on the one screen.
ISSUE : not easy to tell which cols have filters - the blue on light grey just isn't distinctive. I'd like to change the colors when the col is used to filter. Ideally the colors of the actual filter "arrow", but even changing the background color of the col heading would be better than nothing.
Any suggestions??

ANDY

 

[onedtent]

answer in this thread

_______________________________________
_______________________________________

 

[wotgoesup]

OK so I can't change the "arrow" directly.
Is there VBA code that I could use to change the color of the heading if it's a filtered col?

 

[SkipVought]

Hi,

Yes, it can be done with VBA. Please post in Forum707.

Check out the Filters Collection.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]