Complicated Conditional Formating / IF Statement

[Coors]

I don’t know if this is even possible, but I want to conditional format cells with an if statement (something to that nature). I attached an excel file to aid in my question. Basically I want it to be color coded to alert users
Red if no action is required because info is left out
Yellow if info is available so take action
Green if all is complete and nothing needs to be done.

If G2 does NOT have data then cell H2 has red fill
If G2 does have data then cell H2 has yellow fill
And finally if I2 is filled out cells A2:I2 are green filled

I can’t seem to figure out a start on this. Any help would be appreciated.

[martindwilson]

in col h your three formats are
=$G2="" red
=AND(ISNUMBER($G2),I2="") yellow
=AND(ISNUMBER($G2),ISNUMBER($I2)) green
a2:g2 and I2 need a seperate one of only
=AND(ISNUMBER($G2),ISNUMBER($I2)) green

[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.

[Coors]

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,

[NBVC]

Here is your sheet re-attached and hopefully fixed...

The <> means does not equal... so in this case check that cell does not equal null (is not empty)....

[Coors]

Works great, thanks for help and explaination