| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format when autofilter engaged
I have autofilter engaged. When I choose a filter from one of the columns,
I'd like to conditionally format the column to show in a color to further denote it is the one currently on filter option. Formula? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional format when autofilter engaged
Hi
take a look at the sample file at Debra Dalgleish's site http://www.contextures.com/FilterHighlightList.zip -- Regards Roger Govier "ttbbgg" wrote in message ... I have autofilter engaged. When I choose a filter from one of the columns, I'd like to conditionally format the column to show in a color to further denote it is the one currently on filter option. Formula? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional format when autofilter engaged
Roger;
This does look valuable, however creating a UDF is a little beyond me as it seems to entail me creating my own initial filter logic rather than using the autofilter available. Although I have reviewed and understand the concept I was hoping for an easier way. "Roger Govier" wrote: Hi take a look at the sample file at Debra Dalgleish's site http://www.contextures.com/FilterHighlightList.zip -- Regards Roger Govier "ttbbgg" wrote in message ... I have autofilter engaged. When I choose a filter from one of the columns, I'd like to conditionally format the column to show in a color to further denote it is the one currently on filter option. Formula? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional format when autofilter engaged
I looked further on the site, and the FilterColor.zip seemed to help me more
because I simply copy/pasted the VBA script into my own sheet. It's a general script dependong on the Autofilter to be engaged, so it worked. "ttbbgg" wrote: Roger; This does look valuable, however creating a UDF is a little beyond me as it seems to entail me creating my own initial filter logic rather than using the autofilter available. Although I have reviewed and understand the concept I was hoping for an easier way. "Roger Govier" wrote: Hi take a look at the sample file at Debra Dalgleish's site http://www.contextures.com/FilterHighlightList.zip -- Regards Roger Govier "ttbbgg" wrote in message ... I have autofilter engaged. When I choose a filter from one of the columns, I'd like to conditionally format the column to show in a color to further denote it is the one currently on filter option. Formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom format date cells-Autofilter doesn't work right | Excel Discussion (Misc queries) | |||
| Format of autofilter selection list. | Excel Discussion (Misc queries) | |||
| Using autofilter and excel form format | Excel Worksheet Functions | |||
| Can I format to always AutoFilter specific cells | Excel Worksheet Functions | |||
| copy conditional format to regular format | Setting up and Configuration of Excel | |||
Linear Mode
