« Free Excel Stuff
Multiple Add-ins »

Filter by Selected Cell’s Value, Cell’s Color or Cell’s Font Color

29th July 2008, 11:57 am by Ron de Bruin

Hi all

After creating and testing a lot of code to filter on normal and on Conditional Formatting colors
I came up with a nice and easy solution I think.

I made this page for Excel 2007
http://www.rondebruin.nl/colorfilter2007.htm

Suggestions are welcome

Ron de Bruin
http://www.rondebruin.nl/tips.htm

Category: Filtering, Excel12  |  Comment (RSS)  |  Trackback

3 Comments

  1. sam:

    One has to be a bit careful when copying from a filter table

    The copy rules have changed in Excel 2007

    In Excel 2003 and below - When you copy from a filtered table only filtered cells get copied. The exception to this rule is if there are more than 8192 areas

    In Excel 2007 - When you copy from a filtered table
    - Only filtered cells get copied, provided you have selected the entire table and then applied a filter
    - Entire Table gets copied if you have selected only the header rows and then applied a filter

    The exception for the copy rule is also 8192 areas - in Excel 2007

    Sam

    30 July 2008, 6:49 am

  2. Ron de Bruin:

    Hi Sam

    The example on my site will not work when you insert a table.
    I never use tables, but I will make it clear on the site and put a example for tables also.

    Thanks for your reply

    30 July 2008, 7:37 am

  3. Ron de Bruin:

    Hi all

    I update the page today

    Code is working for a Table and a Normal range now.
    http://www.rondebruin.nl/colorfilter2007.htm

    2 August 2008, 3:13 pm

Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

Leave a comment