Every Other row...

G

Gee...

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

Andy Brown

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

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
 
Top