Is it possible to use 2 different fonts in 1 excel cell?
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
|