Every Other row...

[Gee...]

Is there a way to automate filling every other row...like
the old computer paper used to be green and white?

 

[Andy Brown]

Is there a way to automate filling every other row...like

the old computer paper used to be green and white?

As stated by JulieD yesterday ;

select your worksheet (or the used range) and choose
format / conditional formatting
select formula is and type
=MOD(ROW(),2)=0
click on format
go to Patterns, choose a fill colour
click OK twice

 

[Ron de Bruin]

Hi Gee

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