MrExcel Publishing
Your One Stop for Excel Tips & Solutions

formats through cell references

Posted by steven scaife on October 02, 2001 5:40 AM

I have a sheet that looks at the value of a cell via
=sheet1!cell number

If the text in a cell has the line break and says

terms: 'this is bold and underlined
term1 'standard font for the next 3 lines

through that cell reference it pulls the text through but it is all bold and underlined. I only need the top part TERMS to be in bold and underlined.

I am trying a with statement but it only formats the original text and not the text pulled through from the formula

can anyone help me please.

cheers in advance if you can


Posted by Mark W. on October 02, 2001 8:00 AM

Character formatting can only be applied to text
and is not propagated to a cell containing a
reference to the cell with the formatted text.