Delete all grouped rows of data where group does not include row of colored text

Hi. I've included a small portion of an excel sheet that I build every day for a user. Rows of data are grouped by an M-number. Each M-number consists of a number of operations (OPSEQ) and I'm changing the font color where an operation is started before the previous operation is reported complete. I found out my user only wants to see an entire M-Number grouping (All operations for an M-number) where the font color is blue or red on one of the operations and he has been manually deleting groupings of rows he does not want to see.

I'm thinking there has to be a way to handle this through programming but I can't wrap my head around this. Any ideas are welcome. either delete unnecessary rows or move necessary rows to another sheet?

Hi Glenn, Sorry so long to respond. To answer your first post:
1. yes but I want to delete all of the rows for each of those orders. 2. Color doesn't matter at this point, I just need to get rid of all the clean orders so user can print a short version of the report that includes only those orders he needs to get fixed. 3. I'm running Excel 2010.

I ran your code on my excel sheet and the end result is great but after running the code, I see all of the blank rows where the clean orders were wiped. If I save the file, close the spreadsheet and reopen the saved file then the blanks are gone and only the rows I expect are visible. Any idea why it takes a save/reopen to see the changes?

I tried this multiple times and got the same result each time. I also tried removing the blanks manually and via an edit tool but neither works. thanks

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

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…

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation)
David Miller (dlmille)
Synopsis
In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …

The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data.
Rather than update each graph to point to a different set within a static set of data, t…