Color every other row

[M&M]

How can i Color every other row in grey, in a dynamic range?

Any help/ideas greatly appreciated

 

[tiptoe]

Try this

http://www.techonthenet.com/excel/questions/cond_format2.php

 

[Gary''s Student]

Sub everyother()
For i = 1 To 100 Step 2
Cells(i, 1).EntireRow.Interior.ColorIndex = 48
Next
End Sub

adjust the limits to suit the range.