Loop through multiple columns and rows at once.

[orcas]

Thank you for your response . Yes, I am looking at every sixth column

----The stated conditions apply to every sixth column in the spreadsheet as long as there is data in the unshaded cell.

----no, the shading doesn't count as long as long as the even rows are being compared with corresponding odd ones, so in case some Mr clumsy fingered user comes along, it wouldn't have changed the desired outcome

--- Yes, i'd be happy to throw a party if the routine halts once it has found a row to color.

I appreciate your help so far on this Mikerickson.