Conditional Formatting Based on Less Than Dates in Two Columns

[Timberwolf]

Hi all, I'm sure this is a easy one but I'm hitting a wall. I want to turn H2 green if it is less than G2. I know you go to Conditional Formatting >Highlight Cell Rules >Less than and then go through that to set up the colours and font but, how do you apply it for H3<G3, H4<G4, and so on. Thank in advance for any help.

 

[Fluff]

Select H2 down to the bottom of the data & in Cf New rule > use a formula & enter
=H2<G2
& select a format.

 

[arthurbr]

Select the range in both columns ( G2:H100, say) Cond form - New rule - use a formula - and enter =$H2<$G2 and format as required.

 

[Timberwolf]

Sorry should have mentioned that I only wanted the H column to be highlighted So Fluff yours worked thank you. how to I get it to do nothing when G2 has a value but H2 is blank?

 

[Fluff]

Try
=AND(H2<>"",H2<G2)

 

[Timberwolf]

Perfect! Thank you

 

[Fluff]

Glad we could help & thanks for the feedback