How to format only a part of a formula in Excel2007

[JARHTMD]

Col M contains a keyed value for "trip segments". If the trip was made w/o stopping Col M = 1; one stop = 2; two stops = 3; etc

M2 = " Stopped along route on "&(SUM(M17:M382)-COUNT(M17:M382))/COUNT(M17:M382)*100&"% of trips"

That is not 100% accurate, but it's close enough. More than 1 stop will be so infrequently that it is negligible.

I would like to make the computed % BOLD. "Stopped along route on 23% of trips"
M2 = " Stopped along route on "&(SUM(M17:M382)-COUNT(M17:M382))/COUNT(M17:M382)*100&"% of trips"

How do I do that? When I click within the formula, the Font, etc on the Home tab are grayed out.

 

[mfexcel]

I believe that cannot be done with functions or formatting directly.
Here's a workaround for your consideration:
Format part of a formula result… A workaround (non-VBA) solution | wmfexcel