change the default worksheet to always format formulas blue?

  • Thread starter Thread starter dontgue
  • Start date Start date
D

dontgue

I change the color of all formulas in my spreadsheet to blue, to make it easy
to see the places where data input is needed (the "black" formatted cells).
Is there a way to change the default worksheet to always format formulas blue?
 
It wasn't clear to me what you were coloring... the font for the value displayed by the formula or the cell's background color. Here is a macro to change the font color...

Sub MakeFormulasBlue()
Worksheets("Sheet1").Cells.SpecialCells(xlCellTypeFormulas).Font.Color = vbBlue
End Sub

and this one to change the background color...

Sub MakeFormulasBlue()
Worksheets("Sheet1").Cells.SpecialCells(xlCellTypeFormulas).Interior.Color = vbBlue
End Sub
 
I am referring to the font for the value displayed by the formula. Thanks
for the macro. Can I create a button that will be available in all opened
files?
 
Only if you place the code into Personal.xls or an add-in.

Then you simply add a button to a Toolbar and assign the macro to that
button.


Gord Dibben MS Excel MVP
 
In 2007 it would be Personal.xlsm

You musr create it first by recording a macro to Personal Macro Workbook.

Developer Tab>Record Macro>Store Macro in:


Gord Dibben MS Excel MVP
 
Back
Top