Can font attributes of custom text be changed?

[StargateFanNotAtHome]

Iv'e often wondered if it were possible to change the font attributes
of custom text, i.e., that custom text be red and bold whereas what we
type in is just plain black or blue, whatever. It's never looked
possible but just wondered if in fact there was a way. Thx! D

 

[Gord Dibben]

Not sure what you mean here.

What is "custom text" and where are you typing in black or blue text?

Do you anything you type into a cell to bold red?

You can format cells to be bold red.


Gord Dibben MS Excel MVP

 

[StargateFan]

Not sure what you mean here.

What is "custom text" and where are you typing in black or blue text?

Oh, sorry, the custom text feature in cell formatting. Sorry I wasn't
clear.

Do you anything you type into a cell to bold red?

I only need red in the usual sense, when we use [Red] when there is a
negative number. Just wondering about changing to other than the
default black or the negative red colour.

You can format cells to be bold red.

Yes, perhaps, but again, we're so used to read meaning a negative
number that that wouldn't be ideal.

Just curious as to how one might change it there, that's all, in the

 

[Gord Dibben]

See John McGimpsey's site for getting up to 6 font colors using Custom
Formatting.

http://www.mcgimpsey.com/excel/conditional6.html

Or simply use Conditional Formatting.


Gord

Not sure what you mean here.

What is "custom text" and where are you typing in black or blue text?

Oh, sorry, the custom text feature in cell formatting. Sorry I wasn't
clear.

Do you anything you type into a cell to bold red?

I only need red in the usual sense, when we use [Red] when there is a
negative number. Just wondering about changing to other than the
default black or the negative red colour.

You can format cells to be bold red.

Yes, perhaps, but again, we're so used to read meaning a negative
number that that wouldn't be ideal.

Just curious as to how one might change it there, that's all, in the

Gord Dibben MS Excel MVP