shade rows in groups of 3 or 4

[sooze]

I found the formula for shading every other line, but I find that a bit hard to read. Is there a formula that will shade groups of rows? For instance, 3 unshaded, 3 shaded, 3 unshaded, etc. I am working with a simple list , so the formula can't be based on info contained in a cell. I'm purely going for readability here.

Thanks so much,
Sue

 

[Barrie Davidson]

On 2002-09-27 12:37, sooze wrote:
I found the formula for shading every other line, but I find that a bit hard to read. Is there a formula that will shade groups of rows? For instance, 3 unshaded, 3 shaded, 3 unshaded, etc. I am working with a simple list , so the formula can't be based on info contained in a cell. I'm purely going for readability here.

Thanks so much,
Sue

Sue, try Conditionally formatting using this formula:

=ROUNDUP(ROW()/3,0)=EVEN(ROUNDUP(ROW()/3,0))

and copy formatting down.

Regards,

_________________

Barrie Davidson
My Excel Web Page
This message was edited by Barrie Davidson on 2002-09-27 12:56

 

[Juan Pablo González]

Take a look here:

http://www.cpearson.com/excel/banding.htm

 

[sooze]

I think I can do that! Thank you so much, my students thank you as well.

Sue