EXCEL KEYBOARD SHORTCUT FILL COLOR HOW TO
EXCEL KEYBOARD SHORTCUT FILL COLOR UPDATE
EXCEL KEYBOARD SHORTCUT FILL COLOR PRO
EXCEL KEYBOARD SHORTCUT FILL COLOR CODE

EXCEL KEYBOARD SHORTCUT FILL COLOR PRO

It’s a deep topic – dark, ocean blue (see what I did there?).Īnd for VBA, I suggest my friend Jon Acampora’s VBA Pro Course. This technical documentation from Microsoft has all the gory details of how colors in Excel work. This exercise takes advantage of Excel’s color system and VBA.

EXCEL KEYBOARD SHORTCUT FILL COLOR CODE

This one-line macro code saves me lots of time when I’m marking up my worksheets, and I hope you can use it too. When I hit that keystroke, I get a green cell. Select Options and type your keyboard shortcut.įor example, I assigned Ctrl + Shift + G to the Green macro. To assign keyboard shortcuts to the macros you created, go to Developer | Macros and select the pertinent macro (Red, Yellow or Green). Simply click to Developer | Visual Basic and paste the below code into a module under your Personal.XLSB workbook. Wouldn’t it be great to just make our own keyboard shortcuts to fill cells? For example, Ctrl + Shift + R, and our selection is filled red, and so forth. It requires precise, time-consuming, pointing-and-clicking from the mouse. One thing we can all agree on, though, is that filling cells from from the home ribbon is annoying. And maybe you have your own (please leave it in the comments!). Yellow means either neutral, or that I haven’t decided yet! Red cells indicate I need to take action on something, while green means all systems go.

Intrigued This exercise takes advantage of Excel’s color system and VBA. For example, I assigned Ctrl + Shift + G to the Green macro. Just click on Insert Function to insert it into your selected cell.When exploring a workbook, I like to color-code cells so that I remember what I need to do with that information. Select Options and type your keyboard shortcut.

In the preview section below, you can see the entire function as well as the result.

You can further specify, if you want to return the RGB code (write TRUE) or the long code (write long).

As the cell, select the source cell which you want to return the color code from (here: cell A6).

Click on “Function” on the Professor Excel ribbon.

Select the cell in which you want to insert the function to return the background color.

Then, select the background color function and fill out the fields: Professor Excel Tools comes with many new Excel functions: =PROFEXBackgroundColor() is one of them – it returns the background color code either in RGB or Long format. Simply click on the insert function button on the Professor Excel ribbon. You want an easier method? Yes, there is one! Our Excel add-in “ Professor Excel Tools” can do all that. Solution 3: Comfortably use an Excel add-in to return the background color

EXCEL KEYBOARD SHORTCUT FILL COLOR HOW TO

That way, the text you have typed is inserted in all selected cells. Hi does anyone know how to do a quick keyboard shortcut for changing font color / fill color Anything I can do to keep my hands on the keyboard and avoid. Instead of pressing just Enter on the keyboard, hold down the Ctrl-key and press Enter. Type “Yellow” (or whatever keyword / code you prefer). Select the cell range to insert the background color codes to.Now, only rows with this color are visible. Click on one of the colors you are interested in retrieving the color code from (here: yellow).In the poped-up filter menu, click hover with the mouse over “Filter by Color”.This is the column with the colorful background (here: column D). Use the filter: Click on the small filter icon of the column you want to filter.Click on the Filter icon on the Data ribbon in order to insert a filter.Filters offer to a way to work with background colors: One workaround could be, to add a filter. You can use keyboard shortcut without the shift key, but you have to remember that many shortcuts in Excel are, by default, assigned to other tasks. Click any cell and use Ctrl + Shift + Q to fill it with color. But if that’s not the case, why don’t we look for a workaround? When you click OK, the macro starts to record your movements.Now, you need to fill any cell with the desired color and click the Stop Recording button.

EXCEL KEYBOARD SHORTCUT FILL COLOR UPDATE

Do you really need the background color code retrieved by a function? Yes, there might be reasons, for example when you want to automate or frequently update the file.

That – as usually – means that you have to use a VBA macro. Unfortunately, Excel does not provide any built-in method to retrieve the color of the cell background. Solution 1: Use a workaround to achieve your goal

Excel keyboard shortcut fill color