Does an Excel Keyboard Shortcut to Highlight a Cell Yellow Exist?
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...
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
2 Answers
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.
Another much more flexible approach is using an AutoHotKey script:
#NoEnv
SendMode Input
; Ctrl: ^
; Shift: +
; Alt: !
^+d:: ; Ctrl + Shift + d (change to your needs)
Send, {Alt}
Sleep, 10 ; wait 0.01 seconds
Send, {h 2}{Down 6}{Right 3}{Enter} ; Select yellow
Return
Alexander Ross has covered the video game industry for a decade, writing deep dives on game design, esports tournaments, VR developments, and gaming culture.
