Thanks Bob. Although not what I wanted to hear...that answers my question. :)

"Bob Umlas, Excel MVP" wrote:

In a FORMULA, you can't do it; in a text string, yuo can select the portion
of the text and then format the font in the usual way.

"jennifer" wrote:

Is there a way to force a certain font in a formula?

I am trying to put a check mark (Wingdings) or text 'Not Valid' (Arial or
other) in the same cell as an indicator.

Thanks!