I am able to format every other row with conditional formatting, but I need
to take it further. The amount of rows update daily and I only want to format
if there is data in that row. (It can look at the first column for a number
1)

So lets say my data is from A5 - N145 today, but tomorrow it may be A5 €“
N205 or A5 €“ N20

I have no problem putting this in a macro where it will first clear all of
the formatting and then reformat accordingly.

Thanks,