How to Bold part of a cell through Conditional Formatting of other means

[soccerballbmw]

Does anyone know an easy way to bold anything before the first parentheses in the column "what i want"? Thank you!

 

[Fluff]

Hi & welcome to MrExcel.
If the cell has a formula, then you cannot change the format of part of the cell.

 

[xlhelp15]

How about this,

Unit	$	Output
100	$100	100 ($1,000)
200	$200	200 ($2,000)
300	$300	300 ($3,000)
400	$400	400 ($4,000)

Sub Font_Bold_Changes()
With Worksheets("Sheet1").Range("H2:H5")
    .Characters(1, 3).Font.Bold = True
End With
End Sub

As fluff said, this can be achieved post it changes to values.

 

[Fluff]

That will not work if the cell has a formula, which is what the OP is showing.

 

[xlhelp15]

That will not work if the cell has a formula, which is what the OP is showing.

Yes, Fluff. I totally agree with you. I just mentioned the note under the code that this can be achieved post it changes as values which i have given as an additional info.

 

[soccerballbmw]

Thank you very much! I can paste values in another column and use this. I appreciate you both!

 

[Fluff]

Glad we could help & thanks for the feedback.