Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sub total
Hi there
Is is it possible to do the following: 1. run a sub total so that the sub totals are all highlights bold or in a different colour 2. extract only the sub total rows from the spreadsheet? thanks Cathy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sub total
You need to use conditional formatting or VBA for this, I assume you want
the subtotaled amount/count etc to stand out? This is how I do it: Assume for simplicity that you are subtotaling the range A1:B100 and for every total and finally the grand total you want the data in B that are subtotaled and totaled bold. Select all the data from B2 (we assume a header is in A1 and B1) to the last data pertaining to the grand total with B2 as the active cell (if you select using the mouse from B2 downwards B2 will be the active cell) Now do formatconditional formatting, formula is then in the formula is box put =ISNUMBER(SEARCH("Total",$A2)) click the format button and select bold font and click OK twice -- Regards, Peo Sjoblom "Cathy" wrote in message ... Hi there Is is it possible to do the following: 1. run a sub total so that the sub totals are all highlights bold or in a different colour 2. extract only the sub total rows from the spreadsheet? thanks Cathy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
Total column changes colors when total equals sum of other columns | New Users to Excel | |||
calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions | |||
Pivots - Auto calc % Sub total is of grand total | Excel Discussion (Misc queries) | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions |