Filter Highlight

[ashleynjones]

Hello all!

My supervisor requested that I try to find a way to highlight a filter when it's in use. I googled "Excel filter highlight" and this is what I found:

http://blog.livedoor.jp/andrewe/archives/19415538.html

Now, it worked the first time I used it, but now...nothing. I have removed the module, reformatted, and still nothing.

Any ideas?

Thank you!

 

[Nalani]

There are many "Filter Highlight" code out there. If you read the comments from the link you posted, you will see the below.

I recently added a sample to my site that colours the heading cells for filtered coloumns, and overcomes the problem of lingering colour, after Show All is selected, or the AutoFilter turned off:

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

Under Filter, look for 'Colour Filter Headings'
Posted by Debra Dalgleish at April 21, 2005 04:32

Try this one. There is even a sample Workbook to download.

 

[ashleynjones]

It was kind of confusing for a rookie...I will keep searching to find a code that will work.