There are a couple of downloads at the Debra Dalgleish website that can do that.
Take a look at number FL0018 and FL0014. I have not used them ...
http://www.contextures.on.ca/excelfiles.html
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
"AJenkinsNWLDC"
wrote in message
Hello,
I have a sheet of orders and i have recently redesigned the sheet to contain
lists. I wanted my employess to be able to search easily, and without much
excel knowledge i came up with this. However, as i have about 23 columns of
data it has become difficult once somebody has filtered to find out which
list is filtered. There is a little blue triangle instead of black, but some
of my employees are struggling. I was wondering if there was a way that we
could turn the whole filtered column red or yellow, to make it blatently
obvious.
Any help would be greatly appreciated.
Cheers