Excel 2007 : Conditional Formatting formula

What I have is a dataset that is organzied by year and then by quarter within each year.
[ 2011 ]
[1][2][3][4]

I also have data that has a "launch year" "launch quarter" "out year" and "out quarter" (as in out of production)

To conditionally format it I've alredy got the formula to determine where to highlight the years but I'm having trouble then erasing or adding to the fill depending on the quarter data.

Here's what I've got so far.
=AND($A7<=G$3,OR($C7>=G$3,$C7=0))
A7 is the launch year
C7 is the out year

G3 is the year header as shown above (2011, 2012, etc.)

B7 is the launch quarter
D7 is the out quarter

Any help with the quarter thing is MUCH appreciated!!!!