ms excel help: Autofill Color for altenative rows

[blueangel]

i have a spreadsheet with 50 rows. i would like to know if there is a way to set up msexcel to fill every other row with a color. please let me know if there's a way to do this. thanks.

[Tom Urtis]

To hilite even numbered rows:
Select the range of interest.

Format > Conditional Formatting > Formula Is
=MOD(ROW(),2)=0

Select your formatting color, click OK, OK.

[TheLabel]

5 posts about excel right in a row...strange...

[Tom Urtis]

Not really so strange...I just found this board last night and hunted for the more recent Excel questions. Being a holiday weekend in the States, not much activity on this board since then I guess.