Excel Formulas and Partial Cell Formatting: Bold, Italic, or Color Text
Question details
The user wants an Excel formula result to include line breaks and apply different formatting to selected words within the same cell.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A formula combines text and needs to display selected words in bold, italics, or different colors while remaining in one cell.
- Observed behavior
- A standard Excel formula applies one cell format to the entire result and cannot apply rich-text formatting to only part of the returned text.
Decide whether the cell must remain formula-driven and update automatically. If it does, partial formatting is not supported by a normal formula; if the result can become static text, a macro or manual formatting can be used.
Use a standard formula for text and line breaks, but format the entire cell
Use this approach when the formula must remain dynamic and uniform formatting is acceptable for the complete result.
A normal Excel formula can combine text and insert line breaks with CHAR(10), but the result uses one font style, color, and size for the entire cell. HTML tags such as <b> or <font> are displayed as text rather than interpreted as rich formatting in a standard worksheet cell.
Select the formula cell, open the Home tab, and click Wrap Text in the Alignment group.
Add CHAR(10) between text sections, for example: ="First line"&CHAR(10)&"Second line".
Select the complete cell and use the Home tab's Font controls to apply one font, color, bold style, or italic style to the entire formula result.
Convert the formula result to static text and format selected words
Use this option when the text no longer needs to update automatically and selected words require different formatting.
Use VBA to create and format a static rich-text result
Use a macro when the text is generated from worksheet values and must receive different formatting after the macro runs.
Create Formula Text and Apply Cell Formatting in WPS Spreadsheets
WPS Office is a free, lightweight Microsoft Office alternative with a familiar spreadsheet interface and strong XLSX compatibility. Use WPS Spreadsheets to build formula-driven text with line breaks, apply consistent cell formatting, or convert results to values before formatting selected text manually.
- 1. Open the workbook: Launch WPS Spreadsheet, choose Open, and select the Excel XLSX file.
- 2. Create or edit the formula: Select a cell and enter a formula with CHAR(10) or the equivalent line-break method, then enable Wrap Text from the Home tab.
- 3. Format the cell or static text: Use the font controls to format the complete formula result, or copy the result and use Paste Special > Values before selecting individual words for rich-text formatting.
Frequently Asked Questions
Can an Excel formula make only one word bold inside a cell?
No. A standard Excel formula returns one cell value and cannot apply bold formatting to only part of that value. Replace the result with static text or use VBA to format selected characters.
Can CHAR(10) add a line break without enabling rich text?
Yes. Use CHAR(10) between text segments, then select the cell and choose Home > Wrap Text. The line break works, but all text still shares the cell's overall formatting.
Do HTML tags format text inside an Excel formula result?
No. Tags such as <b> and <font color="red"> are normally displayed as literal characters in a worksheet cell. They do not create partial formatting in a standard formula result.
Will VBA formatting remain dynamic when the source cells change?
Not automatically. VBA can generate and format the text, but the macro must run again after source values change unless additional event-driven code is created.
How can I format selected words without using VBA?
Copy the formula result, use Home > Paste > Values to make it static, double-click the cell, select the words, and apply Bold, Italic, or Font Color from the Home tab.
