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/comm...et.f unctions

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

--
Regards

Roger Govier


"Blue-eyed girl" <Blue-eyed wrote in
message ...
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/comm...et.f unctions