View Single Post
 
Old 11-23-2016, 11:51 PM
Old Old is offline Windows 10 Office 2007
Novice
 
Join Date: Nov 2016
Posts: 12
Old is on a distinguished road
Default

There are plenty of tricks you could do to get fixed. Here is one:

Go to your home tab
Go to conditional formatting
Highlight text that contains (enter the word you want)
Filter and sort
Custom Sort
Sort on cell color

Save your macro

Then all you have to do is delete the rows manually each time.
Reply With Quote