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.