Thanks, I still must be doing something wrong. I select the rows I want and
when I enter the formula all I get is a "false" in row 1. Do you know what I
am doing wrong?

"Gord Dibben" wrote:

Select a gaggle of rows.

FormatConditional FormattingFormula is: =MOD(ROW(),2)=1

Pick a color and you're good to go.

Note: this will mess up if you are using a Filter.

For that you need a different Formula is:

=MOD(SUBTOTAL(3,$A$1:$A2),2)


Gord Dibben MS Excel MVP

On Mon, 12 Mar 2007 10:03:31 -0700, 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?