highlight alternate row in excel

[gopal]

Dear Friends,

i would like to have a command or vba-code for highlighting alternate
row.
e.g. a1..h1, a3...h3, a5...h5, a7...h7

thanks

 

[JLGWhiz]

See if this helps:

http://office.microsoft.com/en-us/excel/HA011373371033.aspx?pid=CL100570551033

 

[Gary Keramidas]

here is some code that will do what you want

Sub banding()
Dim i As Long
Dim ws As Worksheet
Set ws = Worksheets("Sheet1")
For i = 1 To 5 Step 2
ws.Range("A" & i & ":H" & i).Interior.ColorIndex = 37
Next
End Sub