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,

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

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

Conditional Formatting would do the trick for you.

Let's say your formula above is located in cell A1. Then in that cell
do FormatConditional 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".

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

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

"Paul D. Simon" wrote:

Conditional Formatting would do the trick for you.

Let's say your formula above is located in cell A1. Then in that cell
do FormatConditional 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".

--

Dave Peterson