Color cells based on several other cells text

[adam1993]

I need some help with the following question...

If column "I" is blank and cell "F" says either "ABC, BCD, JOF, etc..." (several options) then I'd like to color cells "F" and "G" one color but if cell "F" is blank and cell "F" says either "GFA or OWN" then I'd like to color cell "F" & "G" a different color...


PLEASE HELP

[TABLE="width: 250"]
<tbody>[TR]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[/TR]
[TR]
[TD]ARC/Own[/TD]
[TD]RFI responded[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ARC[/TD]
[TD]approved[/TD]
[TD]YES[/TD]
[TD]GW[/TD]
[/TR]
[TR]
[TD]GC/Sub/Co[/TD]
[TD]need to fix...[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

In this case, I'd like the first row to color F & G color blue if it says one of 2 options and for the third row, I'd like the row to color red if it says one of many options...

 

[Special-K99]

"...but if cell "F" is blank and cell "F" says either "GFA or OWN" ..."

If cell F is blank how can it also be GFA or OWN ?

 

[adam1993]

"...but if cell "F" is blank and cell "F" says either "GFA or OWN" ..."

If cell F is blank how can it also be GFA or OWN ?

I meant to say if "I" is blank like the first portion of the question, typo on my part

 

[adam1993]

Basically, if "I" is blank, I want column "f" to color 1 of 2 colors depending on the text in that cell. And if I add text into "I" to make it not blank, then the color in "F" goes away.

I think that adds some clarity.