Once you get Sloth's highlighting method down,
you can automatically delete those cells
by copying the array to Word and bringing it back.
The conditional format will have changed to regular format.
Now you can Find that format, Replace it with a blank,
Goto Special Blanks
and Delete Shift cells up