I want to color cells in Excel 2010 efficiently by only using the keyboard. However, the Excel shortcut for coloring a cell, Alt + H + H, is not that fast since you have to select the specific color with the arrows on your keyboard - which often is slower than using the mouse.

Quite often, the color you want to select is simply the last used color. When using the mouse, you can quickly color the cell with the last used color, since it's showing on the ribbon as the default color.

However, when using only the keyboard, I haven't found a way to quickly apply the last used color.

I tried to record a macro to do this, but the auto-generated code then referred to the *specific* last color used, not the last used color *in general*.

Does anyone know of a smart macro and/or shortcut that can solve this problem?

Thanks, 
Tarjei