Complicated Conditional Formating / IF Statement

Originally Posted by NBVC

First select A2:I2 and invoke Conditional Formatting

Formula Is: =$I2<>""
click Format and choose Green.
Click Ok..
and click Ok to close.
Now select on H2 and re-invoke Conditional Formatting
Click Add
Formula Is: =$G2="" and choose Red.. click Ok
Click Add
Formula Is: =$G2<>"" and choose Yellow.. click Ok
Click Ok to finish.

First of all Thanks for the great directions and help. This site has amazing talent.

Second, everything worked except cell H2 stays yellow, it will not turn green (i attached the excel file as an example) How can I change this.

Third, I am trying to understand all of this. It all makes sense up until the <> symbols, for example in =$G2<>"" why are the <> included???

Thanks,