Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

Selecting for formatted cells

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?
1 Solution
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:

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

shambaladAuthor Commented:
That works. Thank you.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now