Thread: Conditionally format header when column is filtered
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Conditionally format header when column is filtered
http://www.contextures.on.ca/excelfiles.html#Filter

If filtering within a DataList

FL0018 - Highlight Filtered Headings in List -- In an Excel 2003 List, User
Defined Function, and conditional formatting, highlight column headings
where filters are applied. FilterHighlightList.zip 15kb

If not within a DataList

FL0014 - Colour Filter Headings -- Event code colours the filtered column
headings, when an AutoFilter is applied. FilterColour.zip 9 kb 15-Apr-05


Gord Dibben MS Excel MVP

On Tue, 3 Mar 2009 09:58:01 -0800, jday
wrote:

I have a worksheet containing data filters. Is there any way to program it
so that when a specific column has been filtered, the associated column
header is highlighted (i.e. turns yellow, for instance)?

Reply With QuoteReply With Quote