I agree that using a formula as condition is the right solution.
The formula should test if the value in row 2 is in the interval between col G an H right?
This seems to work: 
=AND(K$2>=$G6,K$2<=$H6)