Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jon Quixley
 
Posts: n/a
Default Autofilter selected arrow color


Is there some way to change the default color of the selected autofilter
arrow from its present black=off / blue=on to something more easy to
spot (eg on=red)

Cheers and thanks


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=392082

  #2   Report Post  
dominicb
 
Posts: n/a
Default


Good morning Jon Quixley

Nope. No way. Can't be done I'm afraid.

However, would a compromise do? Debra Dalgleish has an article which
discusses automatically changing the colours of a row heading when a
filter is invoked.

http://www.contextures.com/excelfiles.html#Filter

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=392082

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel to allow color setting for autofilter drop-down arrow patriceadsl Excel Discussion (Misc queries) 1 April 25th 05 01:16 PM
I want the bar chart with customer selected colors, green color f. junminliu Charts and Charting in Excel 2 March 20th 05 03:12 PM
How do I change the highlight color of selected menu items? PepperVL Excel Discussion (Misc queries) 1 March 12th 05 02:13 PM
Change rollover color on autofilter arrow from blue to red afineline Excel Worksheet Functions 1 February 12th 05 03:30 AM
How do I change the color of the drop down arrow when using the a. SouthBay588 Excel Discussion (Misc queries) 2 November 27th 04 10:29 AM


All times are GMT +1. The time now is 05:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"