how do i highlight every odd row
 

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?

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



"HEATHERSM1" wrote in message
...
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?

That worked! Thank you!!

"N Harkawat" wrote:

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



"HEATHERSM1" wrote in message
...
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?