Alternate Shading

G

Guest

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.
 
G

Guest

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
 
G

Guest

That helps.
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
Click to expand...
 
G

Guest

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
 
G

Guest

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
 
D

Dave Peterson

Another one:

=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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

alternate row shading on filtered data 2
Cond. Formatting, Mod(Row) and cell conditions 2
alternate row shading kept with autofilter 3
shading rows in excel 10
How do I maintain alternate row shading after inserting a new row 4
How do I alternate shading of rows, Excel 2007, no new tabs. 1
Alternate row shading with a filtered spreadsheet 5
Conditional formatting 3

Top