Colour a row or column

There is no shortcut to change the colour of a highlighted row.

This procedure will select the current row and let you set a colour:

Sub EntireRow_ChangeColor()
    Selection.EntireRow.Select
    Application.Dialogs(xlDialogPatterns).Show
End Sub

This one does the same for a column:

Sub EntireRow_ChangeColor()
    Selection.EntireColumn.Select
    Application.Dialogs(xlDialogPatterns).Show
End Sub

Published: 21-Dec-2003
Last edited: 05-Jun-2005 19:28