Adding a formula to format cells

[AzHombre]

I have a formula I use all the time for making negative percentages show in red with parentheses around them. In every new spreadsheet, I have to redo the formula for it to show up. I'm sure there must be a way for it to be in every excel workbook I start but I don't know how. Help please.

This is the formula: 0.0%);[Red](0.0%)

Thank you,

Chuck T.
Mesa, AZ

 

[earthworm]

Select all sheet at once and input formula . it will apply to all sheets together. Its called working on group sheets.

 

[AzHombre]

I have a formula I use all the time for making negative percentages show in red with parentheses around them. In every new spreadsheet, I have to redo the formula for it to show up. I'm sure there must be a way for it to be in every excel workbook I start but I don't know how. Help please.

This is the formula: 0.0%);[Red](0.0%)

Thank you,

Chuck T.
Mesa, AZ

I realized that this isn't really a formula, but a formatting. How can I have it show up in any new workbooks I start, without having to re-input under cell formatting?

 

[earthworm]

I realized that this isn't really a formula, but a formatting. How can I have it show up in any new workbooks I start, without having to re-input under cell formatting?

Condition formatting wont apply on group sheets . You need to apply manually on each or use macro then.

 

[Joe4]

One thing you could do is to create VBA code that loops through all sheets in the activeworkbook, and applies the formatting/formula that you want.
Then, you could store that VBA code in a Personal Macro Workbook. Then it would be available to you at all times, whenever you have Excel open on your computer.
So you could quickly/easily run it against any new or existing workbook. You can even set a keyboard shortcut to quickly run it (I do this with a few of mine).

Alternatively, you could create an Excel template that has all the sheets and formatting that you want from the get-go, and use this template to create all your new files that you want this on.