Selecting for formatted cells

Posted on 2011-05-02
Last Modified: 2012-05-11
Hello -
I have an Excel 2007 workbook with thousands of lines. Many of these lines are 'inactive', and are denoted as such in the workbook with a line through the entry and a background color of blue (see attached image below). There is no conditional formatting associated with these cells. Is there a simple way I can group all of these 'inactive' lines together?
Question by:shambalad
    LVL 50

    Accepted Solution


    you can turn on AutoFilter (Alt - D - F - F) and the click the dropdown at the top of the column and select "Filter by Color > Filter by Cell Color" and select the fill color of the cells in question.

    You cannot filter by text formatting, though, so you may need to make sure that all your strike-through cells share the same fill colour.

    cheers, teylyn

    LVL 7

    Author Comment

    That works. Thank you.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    I've recently been in need of an Excel macro that could add a letter before the text on multiple cells in an Excel document. My English is as it is, so I will try explain what it does diffrently. If you have an excel document with 2000 rows an…
    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now