View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Paul D. Simon
 
Posts: n/a
Default Is it possible to use 2 different fonts in 1 excel cell?

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