Formatting Text Bold within a formula

[ken2step]

Hi All,

Is it possible to format this text created with formula below as BOLD?


TEXT(5000+Deductible_Choice,"$#,##0")

I would like to make just this part of the formula, which is listed below, to be bold so that it will stand out from the other text created.

="The amount of Covered Expenses needed before Fortis Health pays 100% - "&TEXT(5000+Deductible_Choice,"$#,##0")

Here is the result of the formula and what I want it to look like:

The amount of Covered Expenses needed before Fortis Health pays 100% - $5,500

Cheers to all,
Ken

 

[paulcoats]

You can use a MACRO to combine the 2 cell values (one in regular font adn one in bold) and bold the cell values from the bold cell. Like this:



Startrow = 18
Endrow = 200
ValueColumn = 14
ColBold = 12
ColReg = 13
RowNum = Startrow
'Loop through each cell
Do While RowNum < Endrow
RegValue = Cells(RowNum, ColReg).Value
RegValLength = Len(RegValue)
BoldValue = Cells(RowNum, ColBold).Value
BoldValLength = Len(BoldValue)
Cells(RowNum, ValueColumn) = BoldValue + RegValue
Cells(RowNum, ValueColumn).Select
With ActiveCell.Characters(Start:=1, Length:=BoldValLength).Font
.FontStyle = "Bold"
End With
RowNum = RowNum + 1
Loop

 

[Siavashhn]

I found the ultimate solution:
you need to put your code in VBA.
I defined a button (which you can put your code in Worksheet_SelectionChange or Worksheet_Activated) and in the VBA I concatenate i6 and j6 together. then with "Range("k6").Value = Range("k6").Value" I make the formula to static text, then do what I wana do with the text and part I want

Sub Button2_Click()
    Range("k6").Formula = "=i6 & j6"
    Range("k6").Value = Range("k6").Value
    
    Range("k6").Font.Bold = False
    Range("k6").Characters(1, 3).Font.Bold = True
    Range("k6").Font.Italic = False
End Sub