Shortcut in Excel

[Jake Rich]

Is there a keyboard shortcut in Excel that will change a highlighted row's
color? I know how to highlight a row (shift+space), but after that I don't
know the shortcut to change its color.

Thanks!

 

[Bernie Deitrick]

Jake,

There is no built-in shortcut: you would need to write a macro and
assign it to a shortcut to get that functionality.

HTH,
Bernie
MS Excel MVP

 

[Dave Smith]

This macro will select the current row(s) and allow you to set a color.

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

HTH
-Dave Smith

 

[Jake Rich]

Thank you Dave!

This macro will select the current row(s) and allow you to set a color.

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

HTH
-Dave Smith