+ Reply to Thread
Results 1 to 3 of 3

Advanced Filter based on cell colours

  1. #1
    Registered User
    Join Date
    07-30-2015
    Location
    London, England
    MS-Off Ver
    2019
    Posts
    22

    Advanced Filter based on cell colours

    How can I advanced Filter based on colour of cells?

    An example would be

    I have Cell C6, D7 and F8 being green.
    Cell C7 is blue.

    Say I want to advanced filter to only show rows that contain blue, resulting filter shows row 7.

    Or say I want to advanced filter to only show rows that contain green, resulting filter to only show row 6, 7 and 8.

    How would I go about doing this in excel advanced filters?

  2. #2
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    206

    Re: Advanced Filter based on cell colours

    Just click the filter button... one of the options on the drop down is "Filter by color".

  3. #3
    Registered User
    Join Date
    07-30-2015
    Location
    London, England
    MS-Off Ver
    2019
    Posts
    22

    Re: Advanced Filter based on cell colours

    But that filters to only one column,

    I'm looking for something that filters to all columns

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Advanced Filter - extracting data to new sheet based on date
    By Martin 1088 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-30-2014, 11:24 AM
  2. Advanced Filter : One Criteria Cell Breaks the Filter - Returns Only Headers
    By PaulGW in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2014, 10:06 AM
  3. advanced filter - button to re apply advanced filter across multiple sheets
    By motmac87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2013, 11:16 PM
  4. Second Advanced Filter does not work based on the data generated from the filter
    By mucc1928 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2011, 02:42 PM
  5. Multi Select List Box based on Advanced Filter
    By swathichandra in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2010, 11:25 PM
  6. Using advanced filter to create new sheets based on database
    By eighty2scrambler in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2009, 03:58 PM
  7. Advanced Filter based on variable.
    By goofy78270 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-04-2007, 10:47 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1