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" wrote in
message
...
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" wrote in
message
...
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" wrote in message
...
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" wrote in message
...
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