Hi,

To add a little more flexibility to my previous example, suppose that the
word "Subtotal" with other text - Subtotal Jan or January Subtotal, then try
something like this as the formula

=FIND("Subtotal",$A1)0

If this helps, please click the yes button.
--
Thanks,
Shane Devenshire


"Unknown User" wrote:

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