Autofilter indication when being used

I have about 15 columns in my spreadsheet and I'm using the Autofilter quite
heavily with the work I'm doing. The problem is I can't always tell which
fields/columns the filter is applied to without manually going through each
one to see what, if anything, is selected. Is there a way for the selected
value to be displayed above the Autofilter line or else for the column to
change color or become boldfaced so I can quickly tell which fields are being
filtered? I am running Excel 2000 by the way. Thanks for your help.

Hi Cheese,

See this recent post from Debra Dalgeish which includes a UDF from Tom
Ogilvy which may answer your requirement.

http://tinyurl.com/ex6vp


---
Regards,
Norman



"Cheese" <Cheese@discussions.microsoft.com> wrote in message
news:261BCE20-0879-45F5-9A0C-8822858154B4@microsoft.com...
>I have about 15 columns in my spreadsheet and I'm using the Autofilter
>quite
> heavily with the work I'm doing. The problem is I can't always tell which
> fields/columns the filter is applied to without manually going through
> each
> one to see what, if anything, is selected. Is there a way for the selected
> value to be displayed above the Autofilter line or else for the column to
> change color or become boldfaced so I can quickly tell which fields are
> being
> filtered? I am running Excel 2000 by the way. Thanks for your help.