| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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)? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to conditionally format an entire column after 1 year from | Excel Worksheet Functions | |||
| How do i change column header from R[1] C format to A1 format? | Excel Discussion (Misc queries) | |||
| Column header format | Excel Discussion (Misc queries) | |||
| Conditionally format points based on a third column | Charts and Charting in Excel | |||
| Format a Filtered range's header? | Excel Programming | |||
Threaded Mode
