VBA code for coloring alternate rows

This code will color the alternate rows in the sheet to blue and white. 

Sub ColorAlternateRows()
Dim i As Long, LastRow As Long
LastRow=ActiveSheet.Cells(Rows.Count,1).End(xlUp).Row
For i = 2 To LastRow
  If i Mod 2 = 0 Then
    ActiveSheet.Rows(i).Interior.Color =RGB(176, 224, 230)
  Else
    ActiveSheet.Rows(i).Interior.Color =RGB(255, 255, 255)
  End If
Next i
End Sub


Open the Visual Basic Editor, then paste the code into a new module. Once you have saved the module, you can run the macro by pressing `F5`

You can change the colors to whatever you want by changing the RGB values in the code.

Popular posts from this blog

Formula to Get Country Flags in Google Sheets

Image
I have created a formula to insert country flags in Google Sheets's cells. For this I've used IMAGE, IMPORTXML and SUBSTITUTE functions. In this formula we're taking flag images from Wikipedia.   You can paste below formula in your Google Sheets: =IMAGE("https:"&IMPORTXML("https://en.wikipedia.org/wiki/Gallery_of_sovereign_state_flags","//img/@src[contains(.,'"&SUBSTITUTE(A2," ","_")&"' )]"))  Change A2 with the cell address in which you are typing country name. You need to type first letter of country name in capital letter in order this to work. I have explained this formula in my below YouTube video. You can watch this video to understand how it works:
Read more

Steps to Turn On Offline Access for Google Docs, Sheets and Slides

Image
You aren't connected to the Internet but still want to work on Google Docs files? Then follow below steps to create, edit or view Google Docs, Sheets and Slides files while you're offline. Connect to the internet. Open or Install Google Chrome browser. Install Google Docs Offline Chrome extension. ( Click Here to Open Install Page ) Open Google Drive Click on Settings Check the box next to "Create, open, and edit your recent Google Docs, Sheets, and Slides files on this device while offline. Done Now you can click on File menu of any Google Docs, Sheets and Slides file and click Make available offline to use that file offline. Alternatively, you can right click on files in Google Drive and then click on Available offline. Watch detailed video on this:
Read more