Select column G and Add a new Conditional Format rule.
Choose a formula and set the Format you want to see
In the formula box put in a formula using the first cell that aligns with the top of your selection eg
=$C2<1
which assumes the first row of your selection is row 2.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia