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?

Share This Discussion

Replie(s)

  • Andrea

    April 18, 2016

    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.

    Reply
  • Diggie D

    April 18, 2016

    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.

    Reply

Leave a Comment

Note: By filling this form and submitting your commen, you acknowledge, agree and comply with our terms of service. In addition you acknowledge that you are willingly sharing your email address with AiOWikis and you might receive notification emails from AiOWikis for comment notifications. AiOWiksi guarantees that your email address WILL NOT be used for advertisement or email marketting purposes.

This site uses Akismet to reduce spam. Learn how your comment data is processed.