Excel – Does an excel keyboard shortcut to highlight a cell yellow exist

keyboardkeyboard shortcutsmicrosoft excelmicrosoft-excel-2016

Is there an keyboard shortcut to highlight a cell yellow (or maybe just the most recent color used)?

What I am not looking for (I want something that is preset in excel and more efficient):

  • Alt–H–H + using arrow keys to navigate to yellow in pallette
  • Adding color palette to Quick Access
  • Creating my own shortcut or macro (Ctrl+Shift+#some key#)
  • F4 to repeat last keystroke

Best Answer

No, but you could make one. You have the ability to assign VBA macros to any key you want.

First, open up your personal macro store in the VBE. Press ALT+F11

Then paste this macro in:

Sub HighlightYellow()
'
' HighlightYellow Macro
'
    With Selection.Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .Color = 65535
        .TintAndShade = 0
        .PatternTintAndShade = 0
    End With
End Sub

Now save your personal macro workbook and close the VBE.

Press ALT+F8

Then assign a shortcut to your new macro.

Related Question