View Single Post
  #1   Report Post  
Dave Peterson
 
Posts: n/a
Default

Debra Dalgleish posted a response from Tom Ogilvy to get the filter criteria:

http://groups.google.co.uk/group/mic...00cb43ac5960ae

or
http://tinyurl.com/ajndr

Maybe you could use it in the cell above each filter. Then you could use some
kind of conditional formatting to even color those cells.

(I don't think that there's anything you can do to "fix" those arrows/colors.)

But some things that may make it easier.

If you go through each column to reset the autofilter to show all the data, you
can use:

Data|Filter|Show All
(or even drag that icon to your favorite toolbar)

Tools|customize|commands tab|Data Category
look for ShowAll

And if you're just trying to notice if the worksheet has any filters turned on,
take a look at the row numbers of that filtered range. If they're blue, then
you do.




wolfpack95 wrote:

My eyesight is getting worse and I'm having trouble discerning the blue
or black arrow when using autofilter. Besides increasing the view
percentage (not desirable), is there anything I can do?

--
wolfpack95
------------------------------------------------------------------------
wolfpack95's Profile: http://www.excelforum.com/member.php...info&userid=93
View this thread: http://www.excelforum.com/showthread...hreadid=388697


--

Dave Peterson