Deleting multiple rows containing no conditional formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-2044287%22%20slang%3D%22en-US%22%3EDeleting%20multiple%20rows%20containing%20no%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2044287%22%20slang%3D%22en-US%22%3E%3CP%3EI%20conditionally%20formatted%20the%20entire%20page%20to%20highlight%20cells%20with%20the%20word%20%22Concern%22%20in%20them.%20How%20could%20I%20delete%20every%20row%20that%20does%20not%20contain%20the%20word%20%22Concern%22%20in%20it%20without%20having%20to%20go%20through%20each%20row%3F%20The%20way%20I'm%20trying%20to%20accomplish%20this%20is%20very%20tedious.%20Thank%20you%20in%20advance!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2044287%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2044581%22%20slang%3D%22en-US%22%3ERe%3A%20Deleting%20multiple%20rows%20containing%20no%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2044581%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F62138%22%20target%3D%22_blank%22%3E%40Chris%20Fernandez%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20would%20filter%20the%20colored%20cells%20on%20column%20then%20delete%20all%20the%20rows%20one%20time.%3C%2FP%3E%3CP%3E%3CSTRONG%3Eselect%20a%20cell%3C%2FSTRONG%3E%20that%20contain%20the%20word%20%22Concern%22%20that%20the%20conditional%20formatting%20applied%20on%20it%2C%20%3CSTRONG%3Eright%20click%3C%2FSTRONG%3E%26nbsp%3B%20--%26gt%3B%20%3CSTRONG%3EFilter%3C%2FSTRONG%3E%20--%26gt%3B%3CSTRONG%3E%20Filter%20by%20selected%20cell's%20color%3C%2FSTRONG%3E%20--%26gt%3B%20%3CSTRONG%3Ehighlight%3C%2FSTRONG%3E%20the%20rows%20and%20%3CSTRONG%3Edelete%3C%2FSTRONG%3E%20them%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20If%20my%20post%20helped%20you%2C%20please%20click%20on%20like.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I conditionally formatted the entire page to highlight cells with the word "Concern" in them. How could I delete every row that does not contain the word "Concern" in it without having to go through each row? The way I'm trying to accomplish this is very tedious. Thank you in advance! 

1 Reply

@Chris Fernandez 

 

You would filter the colored cells on column then delete all the rows one time.

select a cell that contain the word "Concern" that the conditional formatting applied on it, right click  --> Filter --> Filter by selected cell's color --> highlight the rows and delete them 

 

* If my post helped you, please click on like.