auto fill

[Mostro di Biscotti]

I have a spreadsheet with 300 rows, and I would like to color fill every
other row. Can that be done in an automatic way of some sort?

 

[JE McGimpsey]

See

http://cpearson.com/excel/banding.htm

 

[DDM]

You can do it with a formula and conditional formatting. The formulas are
here: http://www.cpearson.com/excel/banding.htm. All you have to do is
select the rows and Format > Conditional Formatting. Condition 1 = Formula
is... enter the appropriate formula, then set up the formatting.

 

[Don Guillett]

Sub colorrow()
For i = 1 To 300 Step 2
Rows(i).Interior.ColorIndex = 6
Next i
End Sub

 

[Dave Peterson]

One more option:

Select your range and Format|autoformat
(You may find a pretty one you like!)

You'll have to redo if you insert/delete rows, though.