Auto filter- Highlighting active filter

[Guest]

Hi,

I appreciate that when a filter is active, the arrow turns blue. However, is
it possible to make this more visible, ie: make the actual button yellow for
example? Or even shade the cell which the button sits in, to yellow?

Trivial I know, but it would help if the active filter was more visible!

Many thanks,
MarkO

 

[Roger Govier]

Hi Mark

Debra Dalgleish has an example workbook where she colours the cells with
the active dropdown
http://www.contextures.com/FilterColour.zip

 

[Guest]

Hi Roger,

That's great, it works!
Thanks very much.
Mark

 

[Roger Govier]

Hi Mark

Glad it got you sorted, but the thanks are entirely due to Debra.