Bold in Sub total
Irrelavant anyway thanks!
My concern is about the highligh in bold for the subtotal after subtotal
exercise.
"Dave Peterson" wrote:
You could use format|conditional formatting.
Say your labels look like "header Total" are in column A.
Select the range to format (say A2:Z99)
And with the activecell A2:
Format|conditional formatting
Formula is: =COUNTIF($A2,"*total")0
and give it a nice format.
The $A means that excel will look at that column for the "Total" indicator.
Change that if you used Average, count, or ....
========
Another way...
Use the outlining symbols to the left to hide the details
Select the range to format
Edit|goto|special|Visible cells only
And format the visible cells the way you like.
Unknown User wrote:
Is there any short cut to high light in bold the sub total after the subtotal
exercise.
Your advise is important, thank you very much.
--
Dave Peterson
|