Change the Auto-filter that is "on" to a RED arrow, can't see blu

[Blue-eyed girl]

I find it very difficult to discern which column has the auto-filter "on" as
the is shaded blue and the others arrows are shaded black. I have to view my
spreadsheet at 70-75% all the time since it is so big. It would be wonderful
if that "on" arrow were red - it would show up easily then!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions

 

[Roger Govier]

Hi

Go to Debra Dalgleish's site and download a workbook called
http://www.contextures.com/FilterColour.zip
This provides code which will change the colour of the cell holding the
selected Autofilter dropdown, and makes it much easier to see