Highlighting an entire row

  • Is there a way to make the row that you are working on change color.
    Example: My worksheet has a plain white background. I want to work in row 3 and be able to compare everything in that row by looking across but the rows above and below also have information in them going across 6 columns. I want the entire 3rd row to hightlight to a different color so that I can tell that is the row I am working in. Any suggestions? Ps. I love this site........... You guys rock with your answeres. Thanks for all the previous help so far.

  • Re: Highlighting an entire row

    Simple way: hit SHIFT + Spacebar

    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt

    Old, slow, and confused - but at least I'm inconsistent!

    (retired Excel 2003 user, 3.28.2008)

  • Re: Highlighting an entire row


    Some worksheet code you can modify as needed:

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
        Cells.Interior.ColorIndex = xlNone
        Target.EntireRow.Interior.Color = vbYellow
    End Sub

    If I've been helpful, let me know. If I haven't, let me know that too. 

  • Re: Highlighting an entire row

    You could also create a code that will alternate shading on every second row of the worksheet:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!