• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • 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?
Thanks,
Todd
DeletedAccounts.JPG
0
shambalad
Asked:
shambalad
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

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

0
 
shambaladAuthor Commented:
That works. Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

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