OK...Now that you know the process...try something like this in the condition
statement:

Formula is: =ISEVEN(CEILING(ROW()/3,1))
That will band alternating groups of 3.

Play with it until it does what you want.

Per usual, post back with questions.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"tamiluchi" wrote:

> Thanks, that's a great site.
> What I want to do is shade 3 rows, skip 3 rows. It doesn't show me how to do
> that. Or maybe I just missed it.
> I will save the site though. It seems to offer a lot of help.
>
> "Ron Coderre" wrote:
>
> > Here's a good place to start:
> >
> > http://www.xldynamic.com/source/xld.CF.html#rows
> >
> > Post back with any questions.
> >
> > ***********
> > Regards,
> > Ron
> >
> > XL2002, WinXP-Pro
> >
> >
> > "tamiluchi" wrote:
> >
> > > Hi
> > > I'd like to use alternate shading for 3-row sections. How do I do this?