conditional formatting with merged cells

[madhavi]

i have a table like this


week Numbers

week1 123

234

123

week2 456

234

123


i want to conditional format this table week1 is merged cells. The number of merged cells is dependent on the number of rows on its right and may vary every week . I want to give a color to every alternate week here . how can i do that.can any one please help me

 

[madhavi]

Can anyone help me

I saw the HW of Chandoo for the above problem which creates a helper column etc etc , but my table has merged rows , the above table is not the way it is


week method enquiries

-----------------------------

week1 email 5

coupon 10

-------------------------------

week2 email 13

coupon 16

SMS 13

-----------------------------

for this table i want all the rows of week1 which means method and enquiries too to be grey and similary alternate weeks to get the same format. I need a generic formula cos weeks keep increasing and i am planning to run a macro with all this.

thanks