M
matmich
what would be the formula using conditional formating to shade 4 row
then skip 4 rows, etc
then skip 4 rows, etc
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.
C
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
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
M
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
=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
F
Frank Kabel
G
george stewart
See http://www.cpearson.com/excel/banding.htm
for colour banding
for colour banding
P
Peo Sjoblom
One way
=MOD(CEILING(ROW(1:1)/4,1),2)=1
=MOD(CEILING(ROW(1:1)/4,1),2)=1