Autofilter selected arrow color

[Jon Quixley]

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

 

[dominicb]

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