13K views · 438 reactions | Need to identify cells fast? Conditional formatting to the rescue! | Microsoft Excel | Facebook

Apply alternating row colors using VBA 🎨VBA code here (copy on desktop!) ➡️ Sub ApplyZebraStripes() Dim selectedRange As Range On Error Resume Next Set selectedRange = Application.InputBox("Select a range to apply zebra striping:", Type:=8) On Error GoTo 0 If Not selectedRange Is Nothing Then Dim row As Range Dim isEvenRow As Boolean isEvenRow = True For Each row In selectedRange.Rows If isEvenRow Then row.Interior.Color = RGB(220, 230, 241) ' Light blue color Else row.Interior.ColorIndex = xlN