Is it possible to formatting bold in excel formula?

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

3 Answers

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

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.

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.