You might be able to do this with conditional formatting depending on the version of Excel you are using.
Your profile indicates 2003 but your posted sample suggests 2007 or later.
For example
Formula is:=
Applies to:=
At worst you could add the formula to your sheet in R8 then drag down.
This could be the rule for the rows you want to copy to another sheet.
Just a suggestion, I haven't looked at your first attachment.
[EDIT]
Forgot to upload attachment
I have only applied the formatting to the area contained in the grid,
Bookmarks