# shade rows in groups of 3 or 4

#### sooze

##### New Member
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

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
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

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

Sue

Replies
4
Views
194
Replies
5
Views
164
Replies
1
Views
189
Replies
10
Views
498
Replies
10
Views
334

1,221,200
Messages
6,158,492
Members
451,497
Latest member
Marese

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back