Is it possible to make a word in a formula bold?

[SpielbergRules]

You folks are incredible! Two questions and they were answered almos
as fast as I clicked "SUBMIT NEW THREAD".

I hate to sound as if I am dumping all my problems on you folks, but
really am attempting to try these things before I make a post here.

My next dilemma is trying to make a word within a formula *bold*.

The word doesn't have to be bolded depending on the result. It wil
either appear or not based on the result of the formula. Bu
obviously, if it appears, it [should] be bolded...

Obviously you can't format text on the formula bar. This is somethin
I've wanted to do in Excel for YEARS!

Any gurus out there know?

Thanks for all your instant help everyone.

Mik

 

[Dave Peterson]

Formulas don't support that kind of character by character formatting.

You folks are incredible! Two questions and they were answered almost
as fast as I clicked "SUBMIT NEW THREAD".

I hate to sound as if I am dumping all my problems on you folks, but I
really am attempting to try these things before I make a post here.

My next dilemma is trying to make a word within a formula *bold*.

The word doesn't have to be bolded depending on the result. It will
either appear or not based on the result of the formula. But
obviously, if it appears, it [should] be bolded...

Obviously you can't format text on the formula bar. This is something
I've wanted to do in Excel for YEARS!

Any gurus out there know?

Thanks for all your instant help everyone.

Mike

 

[SpielbergRules]

Thanks for that info. I hope Microsoft can take note of this. I can'
imagine I am the only one who would need this. Or am I?

Thanks again

Mik

 

[davesexcel]

You could try a worksheetchange event
This example says, if A1= Sunday then bold if not then don't bold
enter the code in the worksheet module

Private Sub Worksheet_Change(ByVal Target As Range)
If Union(Range("$A1"), Target).Address = Range("$A1").Address Then
If Target = "Sunday" Then
Target.Font.Bold = True
Else
Target.Font.Bold = False

End If
End If
End Su

 

[Ragdyer]

If you say that it either "displays or not", couldn't you just format the
cell that the formula is in?

 

[Dave Peterson]

It's been asked for lots of times.

But for me, I wouldn't know how to begin:

It sounds pretty difficult to even start if I have formulas like:

="spielbergrules"
="spiel"&"be"&"rg"&"Rules"
=a1&b1&c1
=left(a1,5)&mid(b2,4)&"rules"

=====