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