| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format subtotal rows
I'm trying to find the easiest way to format the rows containing subtotals only. If i just reduce the group to only see the totals and format that, it formats the rows in between as well. Is a macro or conditional formating easiest? -- nihad ------------------------------------------------------------------------ nihad's Profile: http://www.excelforum.com/member.php...o&userid=30285 View this thread: http://www.excelforum.com/showthread...hreadid=500198 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format subtotal rows
CF is easiest, but you may be limited in what you can do. Bold yes, font
size no. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "nihad" wrote in message ... I'm trying to find the easiest way to format the rows containing subtotals only. If i just reduce the group to only see the totals and format that, it formats the rows in between as well. Is a macro or conditional formating easiest? -- nihad ------------------------------------------------------------------------ nihad's Profile: http://www.excelforum.com/member.php...o&userid=30285 View this thread: http://www.excelforum.com/showthread...hreadid=500198 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format subtotal rows
Hide the details
select the range edit|Goto|special|visible cells only format the cells. nihad wrote: I'm trying to find the easiest way to format the rows containing subtotals only. If i just reduce the group to only see the totals and format that, it formats the rows in between as well. Is a macro or conditional formating easiest? -- nihad ------------------------------------------------------------------------ nihad's Profile: http://www.excelforum.com/member.php...o&userid=30285 View this thread: http://www.excelforum.com/showthread...hreadid=500198 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Rows vs SUM() and SUBTOTAL() | Excel Discussion (Misc queries) | |||
| Multiple subtotal rows | Excel Discussion (Misc queries) | |||
| Collapsing Subtotal Rows | Excel Discussion (Misc queries) | |||
| using SUBTOTAL() on rows that have been hidden | Excel Worksheet Functions | |||
| Formatting rows using SubTotal | Excel Programming | |||
![nihad[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
