Incorporating the text formating when Formula in used [Closed]

Question

Incorporating the text formating when Formula in used [Closed]

Report

adikademani

Posts: 6
Registration date: Monday October 24, 2016
Status: Member
Last seen: November 24, 2016

- Nov 24, 2016 at 07:13 AM
yg_be

Posts: 14022
Registration date: Sunday June 8, 2008
Status: Contributor
Last seen: January 25, 2021

- Nov 24, 2016 at 04:07 PM

Hello Guys,

In Cell A1, the text is "abc" (Note that "abc" is underlined). If i choose cell B1 and apply a formula as "=A1", the cell B1 shows "abc" without the underline. Is there a way to incorporate the cell formating like underlines/bold via this formula?

Any guidance is appreciated. Thanks :)

Incorporating the text formating when Formula in used
Copying Conditional Formatting with Formulas Accross Rows ✓ - Forum - Excel
Google sheets drag formula without formatting - Forum - Office Software
How to change date format in excel to dd/mm/yyyy using formula - How-To - Excel
Excel conditional formatting formula multiple conditions - How-To - Excel
Conditional Formating: formula cell text change color ✓ - Forum - Excel

1 reply

Ask a question

yg_be · Answer 1 · 2016-11-24T16:07:55-0500

Answer 1 / 1

yg_be

Posts: 14022
Registration date: Sunday June 8, 2008
Status: Contributor
Last seen: January 25, 2021

4
Nov 24, 2016 at 04:07 PM

I believe you can do that using VBA.

Incorporating the text formating when Formula in used [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!