Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Subtotals format
I have a worksheet with a column for Name and a column for Amount. The
subtotal in the inserted subtotal line does not show the subtotal amount in bold, though the subtotalled name is in bold. Is there some way to show the subtotalled amount in bold as well? Thanks for your help. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Subtotals format
Only by hand,..... or by code, if that's a viable solution.
Vaya con Dios, Chuck, CABGx3 "Quimera" wrote in message news:vz39n.63832$PH1.7410@edtnps82... I have a worksheet with a column for Name and a column for Amount. The subtotal in the inserted subtotal line does not show the subtotal amount in bold, though the subtotalled name is in bold. Is there some way to show the subtotalled amount in bold as well? Thanks for your help. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Subtotals format
Hi
Assuming your Amount is in column B. Select the range of your data in column BFormatConditional FormattingFormula is =FIND("Total",A2) FormatBold This will also embolden your Grand Total row. -- Regards Roger Govier "Quimera" wrote in message news:vz39n.63832$PH1.7410@edtnps82... I have a worksheet with a column for Name and a column for Amount. The subtotal in the inserted subtotal line does not show the subtotal amount in bold, though the subtotalled name is in bold. Is there some way to show the subtotalled amount in bold as well? Thanks for your help. __________ Information from ESET Smart Security, version of virus signature database 4821 (20100130) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4821 (20100130) __________ The message was checked by ESET Smart Security. http://www.eset.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format pivot subtotals | Excel Discussion (Misc queries) | |||
How do you get rid of a 'automatic subtotals' format problem? | Excel Discussion (Misc queries) | |||
bring back ability to format subtotals in pivot tables | Excel Discussion (Misc queries) | |||
How do I use conditional formatting to change subtotals row format | Excel Worksheet Functions | |||
How do I automatically format subtotals in excel? | Excel Worksheet Functions |