oh ok, in that case what you want to do is just expand the range for both the vlookup functions and the conditional formatting "applies to" range to something that will cover the amount of data you would put in... pick something like 10,000 rows and make sure the formulas in columns H to K go down that far.

Hope that helps!