Is it possible to use 2 different fonts in 1 excel cell?

D

Dave Peterson

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:
 
O

OR

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!
 
P

Paul D. Simon

Conditional Formatting would do the trick for you.

Let's say your formula above is located in cell A1. Then in that cell
do Format>Conditional Formatting. Change the Condition 1 field to
"Formula Is" and enter the formula =A1="Neg IBITDA"

Next, click the Format button and change the format (font, font style,
size, color, etc.) to whatever you want.

For "Pos IBITDA", you could either Add a second condition or simply set
the default format for that cell to whatever you want for "Pos" and it
would then only change for "Neg".
 
P

Paul D. Simon

Conditional Formatting would do the trick for you.

Let's say that your formula above is located in cell A1. Then in
Conditional Formatting, change Condition 1 to "Formula Is" and enter
the formula =A1="Neg IBITDA". Now click Format and change the format
(font, font style, size, color, etc.) to whatever you want.

For "Pos IBITDA", you could either Add a second condition, or simply
set the default for the cell to whatever style you want for the "Pos",
and it would then only change if "Neg".
 
D

Dave Peterson

Conditional formatting won't allow the OP to format "Neg" or "Pos" on way and
the remainder of the characters another.
 
Top