Adding formatting to a formula

[Chris Freeman]

Anyway to set up a cell so two fonts can occupy the same
cell within a single formula?

I am trying to add formating via a formula statement,
outside of conditional formatting. My formula looks up
values and uses if statements to return a dashboard
symbol. I'm using wiingdings font to generate the symbols,
but would like text to accompany the symbol. But in doing
so, the text comes up in the wingdings font which is
graphical and unreadable.

Thanks
Chris Freeman

 

[Frank Kabel]

Hi Chris
Excel's formulas can't set specific formats (that is true for UDFs
also).
Tne only solution I could imagine would be to process the
worksheet_change event, check if your cell has changed and apply some
formating

Frank