Conditional formatting multiple rows

Hi Ikaabod,

Thanks alot! That did the job really well, but is there a way to run the loop without having the offset of (2,-7)? Because the entries are done monthly so the offset code would have to be changed all the time to cover the whole table.

I have attached the excel file for a better understanding. Thanks!

Peter