I have a question. How do I find a row that has a color?

The reason I ask is I am looking for text like "mens denim" on a spreadsheet
but
the text could be other places in the document so I want to go to the row
with color gray = 15 then I want to see if there is a row marked "continue".
If there is a row marked "continue" I want to copy all rows and cells up
to the next row with the color gray which would be the end of that section.