Hello everyone!
I would like to make my new inserted row (2 blank rows) in red color.
Is it possible?![]()
Hello everyone!
I would like to make my new inserted row (2 blank rows) in red color.
Is it possible?![]()
![]()
Sub ColourBlanks() Dim Lastrow As Long Dim i As Long With ActiveSheet Lastrow = .Cells(.Rows.Count, "B").End(xlUp).Row For i = 4 To Lastrow If .Cells(i, "B").Value2 = "" Then .Cells(i, "B").Resize(, 5).Interior.ColorIndex = 3 End If Next i End With End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks