Alternate Shading

Hi
I'd like to use alternate shading for 3-row sections. How do I do this?

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?

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?

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?

See www.cpearson.com/excel/banding.htm


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"tamiluchi" <tamiluchi@discussions.microsoft.com> wrote in
message
news:44335F7F-289E-4CC5-BE78-10F3933F6F8D@microsoft.com...
> 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?

That helps.
Thank you so very much.

"Ron Coderre" wrote:

> 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?

THAT's the link I was trying to think of...
(I'll put it where I can easily find it for next time)

Thanks, Chip

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

XL2002, WinXP-Pro


"Chip Pearson" wrote:

> See www.cpearson.com/excel/banding.htm
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "tamiluchi" <tamiluchi@discussions.microsoft.com> wrote in
> message
> news:44335F7F-289E-4CC5-BE78-10F3933F6F8D@microsoft.com...
> > 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?
>
>
>

It won't work since ISEVEN is part of the ATP and is seen as another
workbook by conditional formatting, this adaptation maybe

=MOD(CEILING(ROW()/3,1),2)=0


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Ron Coderre" <ronSKIPTHIScoderre@bigfoot.com> wrote in message
news:84918F19-FAAF-46BF-9621-817EE46E30DF@microsoft.com...
> 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?

True, Peo...thanks

Sometimes I lose track of which functions are in the ATP and which aren't.
(Wouldn't it be nice if the formula bar flagged add-in functions and UDFs
with a symbol or a color or...anything, really?)

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

XL2002, WinXP-Pro


"Peo Sjoblom" wrote:

> It won't work since ISEVEN is part of the ATP and is seen as another
> workbook by conditional formatting, this adaptation maybe
>
> =MOD(CEILING(ROW()/3,1),2)=0
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> http://nwexcelsolutions.com
>
>
>
> "Ron Coderre" <ronSKIPTHIScoderre@bigfoot.com> wrote in message
> news:84918F19-FAAF-46BF-9621-817EE46E30DF@microsoft.com...
> > 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?
>
>
>

Another one:

=MOD(ROW()-1,6)<3



Ron Coderre wrote:
>
> 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?

--

Dave Peterson