Solved: Excel macro to loop through rows, while looping format rows if meet criteria

[colorado_adv]

thank you all for your help.

I see that keeping my range to the used range cuts down on the macro run time severely as opposed to using the "cells.select".