Formulas won't allow this kind of character by character formatting.

OR wrote:

Dave,

If there is a formula in the cell, then how can you designate different
formats? here is my formula:

=IF(SIGN(Q7)=-1,"Neg IBITDA","Pos IBITDA")

Thanks!

"Dave Peterson" wrote:

Does the cell contain text--not real numbers, not a formula.

If yes, select the cell.
highlight the characters you want to change using the formula bar and the mouse.

Use the menu (format|cells) or use the Format icon on the formatting toolbar.



cmock wrote:

--

Dave Peterson


--

Dave Peterson