Alternating cell shading colors for every other merged cell

[james545]

I am trying to get every other merged row to be a certain cell shading
color.
There is some discussion in the newsgroups about alternating colors
for every row, but in my case I had merged cells and the formulas
given didn't turn out right on my tables since they were based on the
row numbers. Does anyone know how to have alternating cell colors for
merged rows? (the merged rows are random sizes)
Thanks.

 

[Ken Wright]

Not an answer to your question I'm afraid, but just for info, most people in
here steer clear of merged cells like the plague - they tend to cause far more
problems than they ever seem to cure. Copying and pasting can become a
nightmare when they are involved, and as you have found, they tend to screw up
nice answers that will usually get you out of a fix, such as the formatting
option you mention.