You can use conditional formatting to and specify the formula:

=MOD(ROW(),2)=0

You would then have the highlight color on all even numbered rows.


"Ibbuggin" wrote:

I have a spreadsheet and I have highlighted every other row. When I delete
or add a row, the highlighting sequence becomes messed up. I then have to go
back and manually highlight every other row. Is there a way to format the
spreadsheet so that when I add or delete a row, the spreadsheet automatically
keeps the "every other row highlighted" sequence in effect?