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.

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003