software

I have a file where I am using the Subtotals function and I would like to
bold just the totals line. I do not want to make all the numbers bold, just
the totals line.
Can somebody help me with this?

Assume the first line of data (not header) included in the column where
totals are bolded is A2 and the first numbers is in B2, select all numbers
starting from B2 to the end so that B2 is the active cell, then do format
conditional formatting, formula is and in the formula box put

=ISNUMBER(FIND(quot;Totalquot;,A2))

click the format button and select bold in the font tab, then click OK twice

replace A2 with the first data cell in your sheet and B2 with the first
totaled number--

Regards,

Peo Sjoblom

nwexcelsolutions.com

quot;Victorquot; gt; wrote in message
...
gt;I have a file where I am using the Subtotals function and I would like to
gt; bold just the totals line. I do not want to make all the numbers bold,
gt; just
gt; the totals line.
gt; Can somebody help me with this?
I know this was asked a long time ago--but for future searchers. I learned
this new neat trick for this.

Collapse your subtotals. Highlight everything going across.
Edit-gt;Go To-gt;Special-gt;Visible Cells only-gt; Bold (may have to bold twice to
get everything).
Expand to see your results!

quot;Victorquot; wrote:

gt; I have a file where I am using the Subtotals function and I would like to
gt; bold just the totals line. I do not want to make all the numbers bold, just
gt; the totals line.
gt; Can somebody help me with this?