color of arrow in autofilter pulldown

  • Thread starter Thread starter Steve Heffelfinger
  • Start date Start date
S

Steve Heffelfinger

Is there a way to change the default color (blue) of the
arrow in the dropdown control?

I have a hard time seeing when the arrow is actually
highlighted and would prefer to use another color, like
cyan or red.

Thanks for your assistance... steve
 
Steve,

You are pointing out a little but seroius problem which
perists since the (very useful) Auto Filter has been
introduced. Unfortunately I could not find any way tWe o
solve this problem. We probably have to wait for version
14, 15 or 16.

Sorry for having no solution

Rolf
 
AFAIK, no one has discovered a way to change the arrow colour. On my web
site, there's a sample file that uses a User Defined Function and
conditional formatting, to colour the heading cells.

On the following page:
http://www.contextures.com/excelfiles.html#Filter

under the subheading 'Highlight AutoFilter Headings', download the file
named FilterHighlight.xls
 
Back
Top