I have an action item spreadsheet I put together which contains a status in
column C. The status is Open, Closed, In-Progress, On-Hold, On-going (these
are part of my validation list). If the action item in the cell is "Closed"
I would like to move the entire row to row 9, without overriding what is
there. So whatever was in row 9 would be in row 10 to make room for the
closed action item. To make things more difficult, I have conditional
formatting to grey out ever other row for reading ease. Any help would be
appreciated.

Thanks!