how do i highlight every odd row

[Guest]

I have a spreadsheet that I am constantly deleting and adding rows to but in
order to make it easier to read I have every other row highlighted. Well,
everytime I cut and paste or insert I lose the formatting on that row and
have to spend more time fixing it. How do I highlight every other row and
have it stay that way?

 

[N Harkawat]

select your range of rows
then delete the current formatting that you got

Then go to Format--> conditional formatting
Select from the drop down "formula is"
and type this
=MOD(ROW(),2)=0

and select the desired format by selecting format-pattern

 

[Guest]

That worked! Thank you!!

select your range of rows
then delete the current formatting that you got

Then go to Format--> conditional formatting
Select from the drop down "formula is"
and type this
=MOD(ROW(),2)=0

and select the desired format by selecting format-pattern