Is it possible to formatting bold in excel formula?

Question

format sample

Here I want to add text a1+b1+c1, But I want to bold b1 text like command module will be bold. Is it possible to bold this word.

2. date formatting

Is it possible to bold date. suppose Date: 08/01/2017

Answer 1

No, you can't. Excel doesn't provide such functionality to apply rich text formatting to part of the formula.

But you can possibly insert a Text Box over the result cell to achieve this. Here is a link that you can read: Formatting part of a formula

Answer 2

Since you can apply rich text formatting to the cells that contain the formula, why not use more than 1 cell and eliminate the display of line between them so the 2 cells look like 1. Then put the word "Date:" in the first cell flush right margin and in the cell next to it, put the formula to gather the date, formatting the cell to flush left margin, and bold that cell.

Answer 3

You cannot format text to italic, but you could change the basic latin letters to corresponding italic unicode characters:

    Function ITALIC(orig As String) As String
        Dim result As String
        Dim c As Long
        result = ""
        For i = 1 To Len(orig)
            c = WorksheetFunction.Unicode(Mid(orig, i, 1))
            If c > 64 And c < 91 Then c = c + 120263
            If c > 64 And c < 123 Then c = c + 120257
            result = result & WorksheetFunction.Unichar(c)
        Next i
        ITALIC = result
    End Function

You may change the text to many other forms as well. https://lingojam.com/ItalicTextGenerator