Sub Total Formats

Thanks, but how do I change the subtotal lines to bold without having to do each line individually?

Dennis
If your text "Blah Blah Blah Total" is in column A :
Select column A.
Go to Conditional Formatting and type Thomas's formula in the FormulaIs box:-
=RIGHT(A1,5)="Total"
Set the format you want and click OK

If you select only some of the cells in column A, starting say from cell A3, then the formula would be =RIGHT(A3,5)="Total"

Celia

Be sure you only see the subtotals on your worksheet. Then highlight subtotals. Select Edit, Go To, Visible Cells Only, OK. Now click on Bold on the Format Bar....or select Format Cells to apply any other format. The result is that only the subtotals will have the special format.

But then if the sub-totals were removed, these steps would have to be repeated every time the sub-totals were re-installed.
This repetition is avoided by using Conditional Formatting instead.
Celia

you can also copy and paste. but when pasting, paste only formats to your entire column. this should work.

cheers

try conditional formatting.

example: cell a3= blah blah Total =RIGHT(A3,5)="Total" Is it possible to format the sub total and total lines in a lengthy report (using the 'data - subtotals command')? I would like to be able to change the font size or make the subtotal line bold or possibly adjust the row height so that the subtotal lines stand out a bit more from the rest of the data.

let's try that again

cell a3= blah blah Total

=RIGHT(A3,5)="Total" : Is it possible to format the sub total and total lines in a lengthy report (using the 'data - subtotals command')? I would like to be able to change the font size or make the subtotal line bold or possibly adjust the row height so that the subtotal lines stand out a bit more from the rest of the data.