I have a spreadsheet containing both formulas and plugged in numbers. I would like to differentiate between the two, and would like to color all the font of cells containing functions in a different color. Any ideas on how to do this?
The only way that I know is to highlight each cell containing a function and add a background colour to the cell from The drop down menu in the Fill Colour icon on the ribbon. I do not know of any way to do this via a shortcut.
You can do it very easily with a VBA macro. It’s so easy a caveman could do it! (no offense if you are a caveman…..lol).Open your workbookCopy this macro to the clip boardSub Find_Cells_With_Formulas()Dim rng As RangeSet rng = ActiveSheet.UsedRangeFor Each cell In rngcell.SelectIf ActiveCell.HasFormula ThenActiveCell.Font.ColorIndex = 3End IfNextEnd SubNext, go to Tools > Macro > Visual Basic EditorInsert > Module Paste the macro into the Module area to the right.Close back to Excel.Go to Tools > Macro > MacrosClick on the macro to highlight it, if it is not already highlighted.Click: OptionsSelect a letter to use as a keyboard shortcut.Close back to Excel.To run the macro, press CTRL + your shortcut letter.The cells with formulas should now have red font. The macro will work on any worksheet in the workbook.
Save my name, email, and website in this browser for the next time I comment.
This site uses Akismet to reduce spam. Learn how your comment data is processed.
To register please enter your E-Mail address then click on the Sign-Up button (Your E-Mail address will be confidential).