+ Reply to Thread
Results 1 to 3 of 3

Hide specific rows based upon color

  1. #1
    Registered User
    Join Date
    03-26-2023
    Location
    Munich, Germany
    MS-Off Ver
    Microsoft Office Professional Plus 2013
    Posts
    1

    Hide specific rows based upon color

    I have an excel chart in which some lines are filled in green, red or blue. All I want is a filter with which I can hide the lines of one or more colors. It really shouldn't be that difficult. But I can't make it. Can someone help me. Thanks.

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,502

    re: Hide specific rows based upon color

    select filter and apply, in the dropdown for the filter selections should be the ability to apply the filter by color, you should be able to select none - showing all, or cell color or font color. cell color should allow you to exclude all colors except one specifically or all the colors and exclude those not colored. Hope that helps.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,937

    Re: Hide specific rows based upon color

    Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."

    A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

    Since you are a new user of this site, on this occasion, I have changed it for you.

    However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

    *Other search engines are available!!!
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. How to hide some rows based on a specific cell value whilst keeping all unused rows hidden
    By Consultant101 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2021, 06:41 PM
  2. ActiveX Checkbox - Hide rows based on color
    By LSDSCS in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-23-2019, 02:41 PM
  3. Click on a cell to hide a range of rows based on color
    By rain1234 in forum Excel General
    Replies: 1
    Last Post: 11-14-2015, 10:12 AM
  4. [SOLVED] Need to hide cell + rows based on color
    By elmnas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-09-2015, 07:06 PM
  5. [SOLVED] First unhide all rows - then hide rows based on specific cell value for a range of cells
    By robbiekh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-22-2013, 05:46 PM
  6. Hide Rows based on cell color
    By Pergo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-02-2010, 03:08 PM
  7. Hide Rows based on cell color
    By jeff.p in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-26-2007, 10:47 PM

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