How to save part format cell in formula? More

@moderators How about opening up the same question which was closed?

Part of a cell can be formatted. Why can’t a macro conditionally format the result of a formula?

You can apply a Cell Style only to a whole cell by a formula or by the Conditional Format feature.

I suggest you to use adjacent cells for differently formatted contents. Use white (or other) background color for eliminating the grey grid lines and use border lines, and a desired alignment for a “single cell like” appearance. You can apply it for cells located in one column, or in one row, or in a two dimensional cell range.

1 Like

Seems same issue in excel. Excel VBA solution: Formatting Text Bold within a formula | Page 2 | MrExcel Message Board