By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills



Step 874 - Ctrl+Shift+Y - Yellow Highlight a Row


Here's a macro on how to highlight a row with the color yellow

Sub YellowRow()

' YellowRow Macro
'
' Keyboard Shortcut: Ctrl+Shift+Y
'
    Rows(ActiveCell.Row).Select
    If Selection.Interior.Pattern = xlNone Then
        With Selection.Interior
            .Pattern = xlSolid
            .PatternColorIndex = xlAutomatic
            .Color = 65535
            .TintAndShade = 0
            .PatternTintAndShade = 0
        End With
        
    Else
        With Selection.Interior
            .Pattern = xlNone
            .TintAndShade = 0
            .PatternTintAndShade = 0
        End With
    End If
    
End Sub

   Table of Contents | Send us your feedback | © 2025 All Rights Reserved | Edit