John

A caveat here..................

Your formula will not survive through filtering

Use this instead =MOD(SUBTOTAL(3,$A1:$A$2),2)=0


Gord Dibben MS Excel MVP

On Fri, 18 Jul 2008 05:53:02 -0700, John C <johnc@stateofdenial wrote:

To keep some rows always on screen, click in the cell just below what you
always want frozen, then go to menu Window--Freeze Panes.

To do the every other row, I did the following:
Highlight Selection where you want it to appear (I would not recommend
conditional formatting the entire spreadsheet).
Clicked in cell A1, went to menu Format-- Conditional Formatting
Condition 1:
Formula is:
=Row()/2=INT(ROW()/2)