Bold Text

Hello Sir,

I required the macro to bold some specific text in cell like:

Below mentioned formula is written in cell

="We are enclosing herewith a cross cheque bearing No. "&VLOOKUP(DATE(YEAR(AJ8),MONTH(AJ8)-1,1),'Yearly EOBI Payment 2014'!$B$6:$H$17,5,0)&" dated "&TEXT(VLOOKUP(DATE(YEAR(AJ8),MONTH(AJ8)-1,1),'Yearly EOBI Payment 2014'!$B$6:$H$17,6,0),"dd-mmm-yyyy")&" amounting"

I want the function macro to bold the specific text which I want to bold from the formula.

Like Function Formula Named As "TextBold"

=TextBold("We are enclosing herewith a cross cheque bearing No.") And
=TextBold(A1)

I want both condition works.

So I may bold the specific text in formula cell using function


Looking forward to your usual cooperation.

Regards,

Game Start Now