T
tamiluchi
Hi
I'd like to use alternate shading for 3-row sections. How do I do this?
I'd like to use alternate shading for 3-row sections. How do I do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron Coderre
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
http://www.xldynamic.com/source/xld.CF.html#rows
Post back with any questions.
***********
Regards,
Ron
XL2002, WinXP-Pro
T
tamiluchi
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.
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.
R
Ron Coderre
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
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
C
Chip Pearson
See www.cpearson.com/excel/banding.htm
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
message
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
message
T
tamiluchi
That helps.
Thank you so very much.
Thank you so very much.
Ron Coderre said: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
R
Ron Coderre
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
(I'll put it where I can easily find it for next time)
Thanks, Chip
***********
Regards,
Ron
XL2002, WinXP-Pro
P
Peo Sjoblom
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
workbook by conditional formatting, this adaptation maybe
=MOD(CEILING(ROW()/3,1),2)=0
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
R
Ron Coderre
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
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
D
Dave Peterson
Another one:
=MOD(ROW()-1,6)<3
=MOD(ROW()-1,6)<3
Ron said: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