Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change the default worksheet to always format formulas blue?
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? -- dontgue |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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(xlCellType Formulas).Font.Color = vbBlue End Sub and this one to change the background color... Sub MakeFormulasBlue() Worksheets("Sheet1").Cells.SpecialCells(xlCellType Formulas).Interior.Color = vbBlue End Sub -- Rick (MVP - Excel) "dontgue" wrote in message ... 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? -- dontgue |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change the default worksheet to always format formulas blue?
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? -- dontgue "Rick Rothstein" wrote: 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(xlCellType Formulas).Font.Color = vbBlue End Sub and this one to change the background color... Sub MakeFormulasBlue() Worksheets("Sheet1").Cells.SpecialCells(xlCellType Formulas).Interior.Color = vbBlue End Sub -- Rick (MVP - Excel) "dontgue" wrote in message ... 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? -- dontgue |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change the default worksheet to always format formulas blue?
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 On Wed, 2 Sep 2009 15:22:01 -0700, dontgue wrote: 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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change the default worksheet to always format formulas blue?
Does this apply to Excel 2007? I can't find the Personal.xls file.
-- dontgue "Gord Dibben" wrote: 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 On Wed, 2 Sep 2009 15:22:01 -0700, dontgue wrote: 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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change the default worksheet to always format formulas blue?
In 2007 it would be Personal.xlsm
You musr create it first by recording a macro to Personal Macro Workbook. Developer TabRecord MacroStore Macro in: Gord Dibben MS Excel MVP On Thu, 3 Sep 2009 06:25:02 -0700, dontgue wrote: Does this apply to Excel 2007? I can't find the Personal.xls file. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change default format | Charts and Charting in Excel | |||
Change Default Number Format | Excel Discussion (Misc queries) | |||
change default setting of accept labels in formulas | Excel Discussion (Misc queries) | |||
Change default format for 'Comment' | Excel Discussion (Misc queries) | |||
How do I change the default number format? | Excel Discussion (Misc queries) |