@miss.excel: Apply alternating row colors using VBA 🎨 VBA code below (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 = xlNone ' Clear the color             End If             isEvenRow = Not isEvenRow         Next row     End If End Sub

Kat: Chief Excel Officer

Open In TikTok:

Region: US

Saturday 11 November 2023 17:05:49 GMT