Color every other row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Any help/ideas greatly appreciated
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to filter rows data based on background color of individual cells 1
Excel VBA - Problem with Closing Print Preview 0
autoformat add or change 1
If using =MOD(ROW(),2)=0 conditional formatting and want diff fill 1
background-color every second row 2
Excel VBA 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Background stays when sorting 2

Back
Top