I need to delete the entire row that includes a cell with a red background. For instance, if cell G7 is the only cell with a red background then I want the entire row 7 deleted AND moved up.

-A1:W25,000 (All of these cells have integers in it)
-I already run a macro to fill a cell red as needed based on my reason (NO CONDITIONAL FORMATTING USED HERE)
-I need any row with 1 or more cells, with the color red, to be deleted and moved up.


Thanks in advance for your help!!!

-Altan