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.
--
HTH

JonR


"Brad" wrote:

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?

"JonR" wrote:

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.
--
HTH

JonR


"Brad" wrote:

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.