how do i highlight every odd row

H

HEATHERSM1

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

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
 
H

heathersm1

That worked! Thank you!!

N Harkawat said:
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
Click to expand...
 
Top