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

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
------------------------------------------------------------------------
SpielbergRules's Profile: http://www.excelforum.com/member.php...o&userid=35981
View this thread: http://www.excelforum.com/showthread...hreadid=557684

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

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

SpielbergRules wrote:

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
------------------------------------------------------------------------
SpielbergRules's Profile: http://www.excelforum.com/member.php...o&userid=35981
View this thread: http://www.excelforum.com/showthread...hreadid=557684

--

Dave Peterson

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

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

Thanks again

Mike


--
SpielbergRules
------------------------------------------------------------------------
SpielbergRules's Profile: http://www.excelforum.com/member.php...o&userid=35981
View this thread: http://www.excelforum.com/showthread...hreadid=557684

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

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 Sub


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=557684

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

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"SpielbergRules"
<SpielbergRules.2abrh0_1151855104.0368@excelforu m-nospam.com wrote in
message news:SpielbergRules.2abrh0_1151855104.0368@excelfo rum-nospam.com...

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

Thanks again

Mike


--
SpielbergRules
------------------------------------------------------------------------
SpielbergRules's Profile:
http://www.excelforum.com/member.php...o&userid=35981
View this thread: http://www.excelforum.com/showthread...hreadid=557684

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

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"

=====
On the other hand, older versions of Lotus 123 allowed you to embed formatting
characters in formulas--bold, colors, blinking were all supported, IIRC.




SpielbergRules wrote:

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

Thanks again

Mike

--
SpielbergRules
------------------------------------------------------------------------
SpielbergRules's Profile: http://www.excelforum.com/member.php...o&userid=35981
View this thread: http://www.excelforum.com/showthread...hreadid=557684

--

Dave Peterson