software

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

Here's a good place to start:

www.xldynamic.com/source/xld.CF.html#rows

Post back with any questions.

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

XL2002, WinXP-Proquot;tamiluchiquot; wrote:

gt; Hi
gt; 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.

quot;Ron Coderrequot; wrote:

gt; Here's a good place to start:
gt;
gt; www.xldynamic.com/source/xld.CF.html#rows
gt;
gt; Post back with any questions.
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;tamiluchiquot; wrote:
gt;
gt; gt; Hi
gt; gt; 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-Proquot;tamiluchiquot; wrote:

gt; Thanks, that's a great site.
gt; What I want to do is shade 3 rows, skip 3 rows. It doesn't show me how to do
gt; that. Or maybe I just missed it.
gt; I will save the site though. It seems to offer a lot of help.
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; Here's a good place to start:
gt; gt;
gt; gt; www.xldynamic.com/source/xld.CF.html#rows
gt; gt;
gt; gt; Post back with any questions.
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;tamiluchiquot; wrote:
gt; gt;
gt; gt; gt; Hi
gt; gt; gt; 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.comquot;tamiluchiquot; gt; wrote in
message
...
gt; Thanks, that's a great site.
gt; What I want to do is shade 3 rows, skip 3 rows. It doesn't show
gt; me how to do
gt; that. Or maybe I just missed it.
gt; I will save the site though. It seems to offer a lot of help.
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt;gt; Here's a good place to start:
gt;gt;
gt;gt; www.xldynamic.com/source/xld.CF.html#rows
gt;gt;
gt;gt; Post back with any questions.
gt;gt;
gt;gt; ***********
gt;gt; Regards,
gt;gt; Ron
gt;gt;
gt;gt; XL2002, WinXP-Pro
gt;gt;
gt;gt;
gt;gt; quot;tamiluchiquot; wrote:
gt;gt;
gt;gt; gt; Hi
gt;gt; gt; I'd like to use alternate shading for 3-row sections. How do
gt;gt; gt; I do this?
That helps.
Thank you so very much.

quot;Ron Coderrequot; wrote:

gt; OK...Now that you know the process...try something like this in the condition
gt; statement:
gt;
gt; Formula is: =ISEVEN(CEILING(ROW()/3,1))
gt; That will band alternating groups of 3.
gt;
gt; Play with it until it does what you want.
gt;
gt; Per usual, post back with questions.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;tamiluchiquot; wrote:
gt;
gt; gt; Thanks, that's a great site.
gt; gt; What I want to do is shade 3 rows, skip 3 rows. It doesn't show me how to do
gt; gt; that. Or maybe I just missed it.
gt; gt; I will save the site though. It seems to offer a lot of help.
gt; gt;
gt; gt; quot;Ron Coderrequot; wrote:
gt; gt;
gt; gt; gt; Here's a good place to start:
gt; gt; gt;
gt; gt; gt; www.xldynamic.com/source/xld.CF.html#rows
gt; gt; gt;
gt; gt; gt; Post back with any questions.
gt; gt; gt;
gt; gt; gt; ***********
gt; gt; gt; Regards,
gt; gt; gt; Ron
gt; gt; gt;
gt; gt; gt; XL2002, WinXP-Pro
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;tamiluchiquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Hi
gt; gt; gt; gt; 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-Proquot;Chip Pearsonquot; wrote:

gt; See www.cpearson.com/excel/banding.htm
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt; quot;tamiluchiquot; gt; wrote in
gt; message
gt; ...
gt; gt; Thanks, that's a great site.
gt; gt; What I want to do is shade 3 rows, skip 3 rows. It doesn't show
gt; gt; me how to do
gt; gt; that. Or maybe I just missed it.
gt; gt; I will save the site though. It seems to offer a lot of help.
gt; gt;
gt; gt; quot;Ron Coderrequot; wrote:
gt; gt;
gt; gt;gt; Here's a good place to start:
gt; gt;gt;
gt; gt;gt; www.xldynamic.com/source/xld.CF.html#rows
gt; gt;gt;
gt; gt;gt; Post back with any questions.
gt; gt;gt;
gt; gt;gt; ***********
gt; gt;gt; Regards,
gt; gt;gt; Ron
gt; gt;gt;
gt; gt;gt; XL2002, WinXP-Pro
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;tamiluchiquot; wrote:
gt; gt;gt;
gt; gt;gt; gt; Hi
gt; gt;gt; gt; I'd like to use alternate shading for 3-row sections. How do
gt; gt;gt; gt; I do this?
gt;
gt;
gt;

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

nwexcelsolutions.com
quot;Ron Coderrequot; gt; wrote in message
...
gt; OK...Now that you know the process...try something like this in the
gt; condition
gt; statement:
gt;
gt; Formula is: =ISEVEN(CEILING(ROW()/3,1))
gt; That will band alternating groups of 3.
gt;
gt; Play with it until it does what you want.
gt;
gt; Per usual, post back with questions.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;tamiluchiquot; wrote:
gt;
gt;gt; Thanks, that's a great site.
gt;gt; What I want to do is shade 3 rows, skip 3 rows. It doesn't show me how to
gt;gt; do
gt;gt; that. Or maybe I just missed it.
gt;gt; I will save the site though. It seems to offer a lot of help.
gt;gt;
gt;gt; quot;Ron Coderrequot; wrote:
gt;gt;
gt;gt; gt; Here's a good place to start:
gt;gt; gt;
gt;gt; gt; www.xldynamic.com/source/xld.CF.html#rows
gt;gt; gt;
gt;gt; gt; Post back with any questions.
gt;gt; gt;
gt;gt; gt; ***********
gt;gt; gt; Regards,
gt;gt; gt; Ron
gt;gt; gt;
gt;gt; gt; XL2002, WinXP-Pro
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;tamiluchiquot; wrote:
gt;gt; gt;
gt;gt; gt; gt; Hi
gt;gt; gt; gt; I'd like to use alternate shading for 3-row sections. How do I do
gt;gt; gt; gt; 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-Proquot;Peo Sjoblomquot; wrote:

gt; It won't work since ISEVEN is part of the ATP and is seen as another
gt; workbook by conditional formatting, this adaptation maybe
gt;
gt; =MOD(CEILING(ROW()/3,1),2)=0
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt;
gt; quot;Ron Coderrequot; gt; wrote in message
gt; ...
gt; gt; OK...Now that you know the process...try something like this in the
gt; gt; condition
gt; gt; statement:
gt; gt;
gt; gt; Formula is: =ISEVEN(CEILING(ROW()/3,1))
gt; gt; That will band alternating groups of 3.
gt; gt;
gt; gt; Play with it until it does what you want.
gt; gt;
gt; gt; Per usual, post back with questions.
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;tamiluchiquot; wrote:
gt; gt;
gt; gt;gt; Thanks, that's a great site.
gt; gt;gt; What I want to do is shade 3 rows, skip 3 rows. It doesn't show me how to
gt; gt;gt; do
gt; gt;gt; that. Or maybe I just missed it.
gt; gt;gt; I will save the site though. It seems to offer a lot of help.
gt; gt;gt;
gt; gt;gt; quot;Ron Coderrequot; wrote:
gt; gt;gt;
gt; gt;gt; gt; Here's a good place to start:
gt; gt;gt; gt;
gt; gt;gt; gt; www.xldynamic.com/source/xld.CF.html#rows
gt; gt;gt; gt;
gt; gt;gt; gt; Post back with any questions.
gt; gt;gt; gt;
gt; gt;gt; gt; ***********
gt; gt;gt; gt; Regards,
gt; gt;gt; gt; Ron
gt; gt;gt; gt;
gt; gt;gt; gt; XL2002, WinXP-Pro
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; quot;tamiluchiquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt; gt; Hi
gt; gt;gt; gt; gt; I'd like to use alternate shading for 3-row sections. How do I do
gt; gt;gt; gt; gt; this?
gt;
gt;
gt;

Another one:

=MOD(ROW()-1,6)lt;3
Ron Coderre wrote:
gt;
gt; OK...Now that you know the process...try something like this in the condition
gt; statement:
gt;
gt; Formula is: =ISEVEN(CEILING(ROW()/3,1))
gt; That will band alternating groups of 3.
gt;
gt; Play with it until it does what you want.
gt;
gt; Per usual, post back with questions.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt; quot;tamiluchiquot; wrote:
gt;
gt; gt; Thanks, that's a great site.
gt; gt; What I want to do is shade 3 rows, skip 3 rows. It doesn't show me how to do
gt; gt; that. Or maybe I just missed it.
gt; gt; I will save the site though. It seems to offer a lot of help.
gt; gt;
gt; gt; quot;Ron Coderrequot; wrote:
gt; gt;
gt; gt; gt; Here's a good place to start:
gt; gt; gt;
gt; gt; gt; www.xldynamic.com/source/xld.CF.html#rows
gt; gt; gt;
gt; gt; gt; Post back with any questions.
gt; gt; gt;
gt; gt; gt; ***********
gt; gt; gt; Regards,
gt; gt; gt; Ron
gt; gt; gt;
gt; gt; gt; XL2002, WinXP-Pro
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;tamiluchiquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Hi
gt; gt; gt; gt; I'd like to use alternate shading for 3-row sections. How do I do this?

--

Dave Peterson