Multiple format single cell that has formula's

B

Brad

Is there a way to have multiple formats in a single cell that has formula's?

What I'm doing specifically is attaching several strings together and it
would be great to be control the format in the cell.
 
J

JonR

Try using conditional formatting. It will take up to three conditions and
will format according to the criteria you specify. You can add a fourth by
setting a default format that Excel will use if none of your other criteria
are met.
 
B

Brad

My question is this
I want the first word to be bold - second word to be italizied - third to be
underlined ,...

Conditional formatting will change the whole cell to be whatever you specify
- but will not change only a portion of the cell to be bold another portion
to be something different

If there are no formulas - one can change the text as I described above.
Was wondering if there was a way with formulas?
 
B

Brad

So you can do it in VBA.

Since you can't record a macro to do this. Would you specify what positions
would have what formats? Do you have a simple procedure that I could look
at?
 
J

JonR

Are you trying to format the results a concatenate formula or something like
that? Interesting problem. I've not tried that before. It might help if I
knew what you were trying to format and the conditions you are trying to
satisfy.
 
B

Brad

Simple Example
in a1 =B1&", "&C1&", "&D1

B1 = Peter
C1 = Paul
D1 = Mary

in A1
Peter needs to be in Times New Roman 10 point - bold - red
Paul needs to be in Arial - underlined 12 point - blue
Mary needs to be 18 font italicizied - purple

My problem isn't quite this easy - but the concept is the same.
 
D

Dave Peterson

Formulas don't support this kind of formatting.

If you convert it to values, you can change the formatting the way you like.
 
Top