SOLVED

Formatting text within a formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1428044%22%20slang%3D%22en-US%22%3EFormatting%20text%20within%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1428044%22%20slang%3D%22en-US%22%3E%3CP%3EAnyone%20have%20a%20suggestion%20of%20how%20(or%20if)%20I%20can%20format%20text%20within%20a%20formula%2Cie%3A%3C%2FP%3E%3CP%3E%3D%22As%20of%20this%20date%2C%20%22%26amp%3BTEXT((C2)%2C%22mm%2Fdd%2Fyyyy%22)%26amp%3B%22%20%2C%20when%20I%20...%22%3C%2FP%3E%3CP%3EI%20would%20like%20to%20underline%20and%2For%20make%20bold%20perhaps%20even%20highlight%20certain%20words%20within%20this%20formula.%3C%2FP%3E%3CP%3EThank%20you%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1428044%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1428061%22%20slang%3D%22en-US%22%3ERE%3A%20Formatting%20text%20within%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1428061%22%20slang%3D%22en-US%22%3ETo%20my%20knowledge%20selective%20font%20formatting%20within%20a%20cell%20is%20only%20possible%20through%20VBA.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1428186%22%20slang%3D%22en-US%22%3ERE%3A%20Formatting%20text%20within%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1428186%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Anyone have a suggestion of how (or if) I can format text within a formula,ie:

="As of this date, "&TEXT((C2),"mm/dd/yyyy")&" , when I ..."

I would like to underline and/or make bold perhaps even highlight certain words within this formula.

Thank you in advance!

2 Replies
Highlighted
Solution
To my knowledge selective font formatting within a cell is only possible through VBA.
Highlighted

Thank you