![]() ![]() The reason is that if you collaborate with someone else the =PROFEX() functions should work for all users – even if they don’t have the unlimited license. Type TRUE for the RGB value or FALSE for the color index.Įasy, right? And the best: Although the free trial version expires after 7 days, this function you can continue to use.As the cell reference, type or select the cell with the font color you want to return.Select the function to insert (here: PROFEXFontColor).Click on Function on the Professor Excel ribbon.Or, you need a little bit more guidance? Insert the PROFEX function with the function tool: Return the font color for free with Professor Excel Tools. Install the add-in and type =PROFEXFontColor(B16,FALSE)įor the font index and =PROFEXFontColor(B16,TRUE) See the screenshot and notice how the different intensities of yellow or purple all have the same number. It does not have sufficient numbers for the millions of colors that are available in modern Excel. This is probably the most convenient method: Use our Excel add-in “Professor Excel Tools”. It does not update as soon as the cell color changes, but only when the cell (or the sheet) is recalculated. Use Professor Excel Tools for returning the font color.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |