Comparing a cell to another cell within a range

[bshafter]

Hey everyone, I am stuck. I am trying to determine if an advertised price is lower than the list prices and return a msgbox if it is true. The list prices for each product are static in cells B8:B29 and the advertised prices are per company and are in C8:c29, D8: D29, etc and correspond to the same row as the list price. How do I compare each advertised price to the respective list price and return a msgbox if the advertised price is lower.

I have created code to do it one column at a time just comparing the activecell to activecell.offset(0,-1), but it is tedious and there has to be a better way.

Thanks in advance for your help!