ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   mixed font styles in the output of a formula? (https://www.excelbanter.com/excel-worksheet-functions/45238-mixed-font-styles-output-formula.html)

trumbore

mixed font styles in the output of a formula?
 
How do i get the solution to a function to display in the correct font
styles? I am using formulas to create long strings of text based on if/then
statements. I would like the output to use different kinds of fonts such as
italics, bold, or greek symbols mixed with standard font displays. Is there
a way to set the font style for the output in the formula?

Dave Peterson

If you're gonna keep the formula, then xl won't support it.

If you convert to values, then you can do what you want (if the value isn't a
real number, that is).

trumbore wrote:

How do i get the solution to a function to display in the correct font
styles? I am using formulas to create long strings of text based on if/then
statements. I would like the output to use different kinds of fonts such as
italics, bold, or greek symbols mixed with standard font displays. Is there
a way to set the font style for the output in the formula?


--

Dave Peterson


All times are GMT +1. The time now is 12:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com