Custom Keyboard Shortcut to COLOR FILL Highlighted Cells?

I copy/paste a good enough information and i like to seperate these automated information into different colored rows using keyboard shortcuts. I can't use Conditional Formatting, because i have to investigate each piece of information before I color it a certain color.


For example: Color Purple, Green, And Red


Press Ctrl+1 = Color Purple
Press Ctrl+2 = Color Green
Press Ctrl+3 = Color Red

Is this possible?

Originally Posted by tigeravatar

Keyboard shortcuts must be letters, they cannot be numbers. But other than that, yeah, it's possible.

Press Alt+F11 to open the Visual Basic Editor (VBE)
Insert -> Module
Type the following code:

Please Login or Register  to view this content.

Then go back to Excel (just re-activate it from your taskbar), and go to View -> Macros -> View Macros
Click on the macro you just created (we named it HighlightPurple) and click Options
There you can specify a keyboard shortcut

Wash/Rinse/Repeat for other colors (be sure to change the name of the macro by adjusting the Sub ...() line)
Here are the recognized colors you can use:
vbBlack
vbRed
vbGreen
vbYellow
vbBlue
vbMagenta
vbCyan
vbWhite
xlNone

Thank you so much for this! You saved me a lot of time. How do i make this effective for every Excel workbook i open? How can i easily apply it to all my past files? Thanks

Hi yakabod

Another way is to record the macros in a personal work book (which you can then hide). The personal workbook will automatically open every time you use Excel, so the macros will then be available.

Regards
Alastair