Changing Font Characteristics Within a Formula

J

jdurrmsu

How do I change the font color and make it bold within a formula? I am
trying to link two different cells with text in them to one cell and I
would like to have the color and font weight changed for just one of
the links. For example...

A1=1
A2=2

I want B1 to show 1(black normal font), 2(red bold font)

Thanks.
 
D

Dave Peterson

Formulas don't support that type of formatting--and neither do real numbers.

Only Text supports it.
 
G

Gord Dibben

Formulas can only return values, including text, but cannot change formatting
of those values.

After returning the value with a formula you could copy and paste
special>value then manually edit the result in the formula bar.

Or you could use VBA to achieve the same result.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining a string of text 3
excel won't sort dates correctly 0
& to combine cells/Keep formats 1
Conditional format color change 2
Countifa RAG auto populating data 0
Combining Text and If statements with varied character (bold, color, etc) formatting. 10
Font color dipicts which formula to use 2
Font color change if cell if null 2

Top