The commands can be found below the font name drop down menu:īold is applied by either clicking the Bold (B) icon in the Ribbon or using the keyboard shortcut CTRL + B or Command + B You can apply different characteristics to fonts such as: To change the font size of the font, just click on the font size drop down menu: Good job! You have successfully changed the fonts from Calibri to Arial for the range A1:C4. The example has both text ( A1:B1) and numbers ( A4:C4) Just click on Insert Function to insert it into your selected cell.The font name can be changed for both numbers and text. 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 That way, the text you have typed is inserted in all selected cells. 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. But if that’s not the case, why don’t we look for a workaround? 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