LinkBack URL
About LinkBacksHi
I'd like to use alternate shading for 3-row sections. How do I do this?
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" <[email protected]> wrote in
message
news:[email protected]...
> 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" <[email protected]> wrote in
> message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks