Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Formatting of SubTotals
I've got a very large spreadsheet where I've used the SubTotal command, but I
want to bolden each sub total and increase the font size. Rather than go through each sub total and add the formatting is there a function where I can apply this the one time so it applies the formatting automatically? Thanks -- David |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Formatting of SubTotals
Hi David
Mark your range of data then FormatConditional FormattingFormula is =ISNUMBER(SEARCH("total",$A1)) Set whatever formats you want The above assumes that column A contains the word total, change to suit -- Regards Roger Govier "David" wrote in message ... I've got a very large spreadsheet where I've used the SubTotal command, but I want to bolden each sub total and increase the font size. Rather than go through each sub total and add the formatting is there a function where I can apply this the one time so it applies the formatting automatically? Thanks -- David |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Formatting of SubTotals
I do this...
I hide the details. then select the subtotal range Edit|Goto|special|visible cells only apply the formatting I want. If I really need this to be mechanized, I'd record a macro when I did it manually. David wrote: I've got a very large spreadsheet where I've used the SubTotal command, but I want to bolden each sub total and increase the font size. Rather than go through each sub total and add the formatting is there a function where I can apply this the one time so it applies the formatting automatically? Thanks -- David -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove automatic formatting of new columns in Excel? | Excel Discussion (Misc queries) | |||
Automatic formatting of Significant Figures .... | Excel Discussion (Misc queries) | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
Improvement to automatic formatting | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |