change the default worksheet to always format formulas blue?

[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?

 

[Rick Rothstein]

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

 

[dontgue]

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?

 

[Gord Dibben]

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

 

[dontgue]

Does this apply to Excel 2007? I can't find the Personal.xls file.

 

[Gord Dibben]

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