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

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