Results 1 to 6 of 6

Thread: Filter Columns by Color
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2005
    Posts
    2,954
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Filter Columns by Color

    How can I filter multiple columns by color?

  2. #2
    Board Regular
    Join Date
    Mar 2015
    Posts
    4,056
    Post Thanks / Like
    Mentioned
    73 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Filter Columns by Color

    If the colours are the result of conditional formatting then consider Advanced Filter
    https://www.contextures.com/xladvfilter01.html
    - adapt the rules applied in CF to create the formulas required by advanced filter

    If the colours are manually applied then you probably need VBA

  3. #3
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    41,390
    Post Thanks / Like
    Mentioned
    100 Post(s)
    Tagged
    21 Thread(s)

    Default Re: Filter Columns by Color

    Quote Originally Posted by Yongle View Post
    If the colours are the result of conditional formatting then consider Advanced Filter
    That is a choice but AutoFilter can still be used manually or by VBA if the colours are there by Conditional Formatting so that would probably be easier.

    The only time you might need to use the rules that applied the CF would be if you had the same colour applied both by CF and directly and you wanted to filter one and not the other - highly unlikely I think.
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the # key in the Reply window
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  4. #4
    Board Regular
    Join Date
    Mar 2015
    Posts
    4,056
    Post Thanks / Like
    Mentioned
    73 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Filter Columns by Color

    @Peter_SSs
    - I should have stated in my reply that I assumed that the question was being asked because auto filter by colour had been found inadequate.
    Last edited by Yongle; Oct 6th, 2019 at 04:54 AM.

  5. #5
    Board Regular
    Join Date
    Mar 2015
    Posts
    4,056
    Post Thanks / Like
    Mentioned
    73 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Filter Columns by Color

    @DougStroud

    The detail of how you are trying to filter would help us address your specific problem

  6. #6
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    41,390
    Post Thanks / Like
    Mentioned
    100 Post(s)
    Tagged
    21 Thread(s)

    Default Re: Filter Columns by Color

    Quote Originally Posted by Yongle View Post
    @Peter_SSs
    - I should have stated in my reply that I assumed that the question was being asked because auto filter by colour had been found inadequate.
    You could be right, perhaps even because the excel version is old and doesn't even have that option.

    It could be though that a macro just to apply multiple colour filters is being requested.

    So little information in the question it is all a guess really. Hopefully the OP will provide enough information to allow a suitable suggestion.
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the # key in the Reply window
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •