Excel query related to Bold function in formatting

In B10 cell Answer is coming Total Count is :- 559 in which all are showing BOLD

I just want to showing 559 as bold and rest and unbold .. !!
Is there any wayout to do so?

Hi vjharry,

If this is one time exercise, you can select 559 only and press bold it.
If you want it to automatically happen for more number of data tables / totals, you can go for macro (vba) solution. Thanks.

Regards,
DILIPandey
<click on below * if this helps>

sir, this 559 is coming through formula ... so how i can make only 559 bold rest unbold?
file is also attached for your reference

Hi Dilip,
dod u find any reply on this

Any other reply which I can expect from u guys...

Hi vjharry,

Hope you read my post#2 completely... I already given you an hint there.


Regards,
DILIPandey
<click on below * if this helps>

I was Expecting without macro in this situation...
Anyways... thanks for your reply.

you cannot change the font format of part of the result of a formula different from the rest