Thanks to everyone for the help. Finally got it to work. I was working on
an existing spreadsheet with every other row already highlighted. Discovered
that I had to clear all highlights, then choose the cells again and apply the
formula. Once I cleared the original highlights and applied the formula, it
worked perfectly. Thanks again.

"Dave Peterson" wrote:

You don't type the formula in the cell.

You select the cell(s) and then
Format|Conditional Formatting|Formula is
(Format is on the worksheet menu bar -- at the top.)


Ibbuggin wrote:

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?



--

Dave Peterson