VBA: If cells in row colored x then x ...

Hey guys, finishing up a project of mine and I'm needing some more VBA help. i've got the code below:

Please Login or Register  to view this content.

What im needing to do is to have the macro look at my variable range (Starting on column H going on to a user defined column) row by row and to add a "Final" column at the end of the dataset. Each cell in the final column will have content dependent on the Color of the cells in the dataset for each corresponding row. IE if row 2 has a single cell in it that is red, then my final cell will need to be red and state "DQ". Otherwise if any row has 1 or more yellow cells but NO RED cells then its final cell must be labeled "REVIEW" and be colored yellow. Furthermore if any row contains NO RED, NO YELLOW, and at least 2 GREEN, then it would need to result in a green QUALIFIED end result. I believe im on the right track with the code above but its not quite there.

Here you go. I've deleted a bunch of the data on the tabs due to its sensitivity but its not needed for the portion I'm needing help on. I'm needing the work done on the "Report" tab. Thanks in advance for any help.