BOLDING SUBTOTALS

Z

zach f

Is there a way to bold subtotals. I want everything on the subtotal line to
be bolded, sometimes the report is very big and right now I have to select
each row and bold each row.
 
K

Ken Wright

How are your Subtotals created?

Data / Subtotals feature or
Pivot table or
Manually?

Are all your subtotals preceded by text such as "Subtotal".
 
F

Frank Kabel

Hi
try:
- select A1:B20
- goto format - Conditional format
- enter the following formula
=ISNUMBER(SEARCH("total",$A1))
- select your format

This assumes column A contain a label with the word 'total' in it
 
K

Ken Wright

Assuming your data is in A1:Z1000, select that range and do format / Conditional
Formatting, change 'cell value is' to 'formula is' and put in
=RIGHT($A1,5)="Total"

Now hit the format button on that dialog box and choose BOLD from the font tab.

Note that IF your data starts in say Columb B, then the formula must read
=RIGHT($B1,5)="Total"

and if you select any other range that does not start in row 1 then you must
adjust the row too. The reference that goes in the formula must be the top left
cell in the selected range.
 
Z

zach f

I do not have the option to choose isnumber(search

I have:
cell vaule is or formula is
between,equal,greater than, etc....
then select my range,
and select another range.

I am on MO 2003?
 
Z

zach f

Ken going off what you said....my range of cells before they are subtotaled
are A2:A448 through L2:L448. I subtotal the amounts that I have in columns
F-L by the parent name of our cusotmers. when I have everything selected I
put in the formula =right($a2,448)="total"
 
K

Kat

if you used data/subtotal you should be able to collapse to showing only
those rows with the subtotals. Do Edit/Go To; special; visible cells only
and then Ctrl B - this should work.
 
K

Ken Wright

I'm assuming then that Col A contains the word TOTAL for each of your subtotals.
If so then with A2:L448 selected, do Format / Conditional Formatting, change
'cell value is' in the dropdown to 'formula is' and put in the following formula
in the space that appears

=RIGHT($A2,5)="Total"

Now hit the format button on that dialog box and choose BOLD from the font tab.
Hit OK and OK again and you are done.

This will bold any row from Col A to Col L where Col A contains the word Total,
which is part of what Data / Subtotals puts in there.
 
Top