PC Review


Reply
Thread Tools Rate Thread

Auto filter- Highlighting active filter

 
 
=?Utf-8?B?TWFya28=?=
Guest
Posts: n/a
 
      15th Feb 2007
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
 
Reply With Quote
 
 
 
 
Roger Govier
Guest
Posts: n/a
 
      15th Feb 2007
Hi Mark

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

Roger Govier


"Marko" <(E-Mail Removed)> wrote in message
news:82A736CD-029E-4AAB-9739-(E-Mail Removed)...
> 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



 
Reply With Quote
 
=?Utf-8?B?TWFya28=?=
Guest
Posts: n/a
 
      15th Feb 2007
Hi Roger,

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


"Roger Govier" wrote:

> Hi Mark
>
> Debra Dalgleish has an example workbook where she colours the cells with
> the active dropdown
> http://www.contextures.com/FilterColour.zip
> --
> Regards
>
> Roger Govier
>
>
> "Marko" <(E-Mail Removed)> wrote in message
> news:82A736CD-029E-4AAB-9739-(E-Mail Removed)...
> > 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

>
>
>

 
Reply With Quote
 
Roger Govier
Guest
Posts: n/a
 
      15th Feb 2007
Hi Mark

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

--
Regards

Roger Govier


"Marko" <(E-Mail Removed)> wrote in message
news:BEB8163D-8E1A-473F-ACFA-(E-Mail Removed)...
> Hi Roger,
>
> That's great, it works!
> Thanks very much.
> Mark
>
>
> "Roger Govier" wrote:
>
>> Hi Mark
>>
>> Debra Dalgleish has an example workbook where she colours the cells
>> with
>> the active dropdown
>> http://www.contextures.com/FilterColour.zip
>> --
>> Regards
>>
>> Roger Govier
>>
>>
>> "Marko" <(E-Mail Removed)> wrote in message
>> news:82A736CD-029E-4AAB-9739-(E-Mail Removed)...
>> > 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

>>
>>
>>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide Raws even the Auto Filter is active Saji Microsoft Excel Worksheet Functions 3 11th Jan 2010 10:42 AM
Data>Filter>Auto Filter in excel 2007? TIJ Microsoft Excel New Users 2 13th Nov 2008 03:28 AM
ranging the filter cells when doing auto filter thread Microsoft Excel Programming 8 25th Apr 2007 11:08 PM
Active Cell in Auto Filter =?Utf-8?B?TWljaGFlbCBMaW5r?= Microsoft Excel Misc 1 1st Aug 2006 04:27 PM
Excel auto filter doesn't recoginize case - won't filter AA from A =?Utf-8?B?TWlrZXk=?= Microsoft Excel Misc 1 29th Sep 2005 08:18 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:32 PM.