Excel Macro that finds red text and fills same row with light blue

I am trying to write a macro that will find all rows with red text in column A of sheet 2 and give that row a light blue fill. I have successfully wrote a macro for one row, but I am not sure how to repeat this without copy/paste since I need it for 200 rows. Here is the macro:

Please Login or Register  to view this content.

I would rather not use conditional formatting since all the other coding for the sheet is in a macro. Although if conditional formatting is much easier, that is fine.

Thanks!

Thank you! This worked