+ Reply to Thread
Results 1 to 2 of 2

change color of inserted rows

Hybrid View

isabella change color of inserted rows 08-27-2010, 03:13 AM
Bob Phillips Re: change color of inserted... 08-27-2010, 04:05 AM
  1. #1
    Registered User
    Join Date
    08-02-2010
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    55

    change color of inserted rows

    Hello everyone!

    I would like to make my new inserted row (2 blank rows) in red color.
    Is it possible?
    Attached Files Attached Files

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: change color of inserted rows

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1