I only want to hight the subtotal rows, not to includes the drop down rows.
Is there any shortcut to highlighted in Bold instead of select it one by one
not to impact on the others rows.

"ShaneDevenshire" wrote:

Hi,

Suppose the word Subtotal appears in column A and you want to bold the
corresponding cells in columns B:D (you could include A if you want):

1. Highlight the range you want to format, here say B1:D100
2. Choose Format, Conditional Formatting
3. From the first drop down chooose Formula is
4. In the next box enter the formula
=$A1="Subtotal"
5. Click the Format button and on the Font tab click Bold under Font Style.

--
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