shading rows with condtl fromat.

[matmich]

what would be the formula using conditional formating to shade 4 row
then skip 4 rows, etc

 

[Chip Pearson]

See www.cpearson.com/excel/banding.htm for example formulas.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[macropod]

You could try:
=MOD(INT((ROW()-1)/4),2)=0
or
=MOD(INT((ROW()-1)/4),2)=1
depending on whether you want to start shaded or unshaded, respectively.


Cheers

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/banding.htm

 

[george stewart]

See http://www.cpearson.com/excel/banding.htm
for colour banding

 

[Peo Sjoblom]

One way

=MOD(CEILING(ROW(1:1)/4,1),2)=1