Format text

  • Thread starter Thread starter Manos
  • Start date Start date
M

Manos

Dear all

I have a formula where i am taken a text and a number

"euro"& text(a1+b1,"0,00")&

There is anyway that i can make euro to appear BOLD but
not the number?

Thanks in advance
Manos
 
Hi Manos
this is not possible with formulas. Formulas can only return values but
not formating information. So: no chance even with a user defined
function in VBA
 
could use conditional formatting
Format it so it's a custom formula w/e the cells are
eg. A1="euro" then define what you want to do with it....

DA
 
this is not possible with formulas. Formulas can only return values but
not formating information. So: no chance even with a user defined
function in VBA
Click to expand...

Well, not with a udf, but it's possible using a Calculate event handler,
ancillary cells and picture links. The Calculate event handler would set copy
the .Text property of the cell containing the formula to the ancillary cell,
then use that cell's .Characters property to format the number portion, then
copy that cell and paste as a picture link on top of the cell containing the
formula. The cell containing the formula would need to have number format ;;;.

This is quite fragile, but it would do what the OP wants. However, if the OP has
never written any VBA, this would be impractical.
 
Harlan Grove said:
...

Well, not with a udf, but it's possible using a Calculate event handler,
ancillary cells and picture links. The Calculate event handler would set copy
the .Text property of the cell containing the formula to the ancillary cell,
then use that cell's .Characters property to format the number portion, then
copy that cell and paste as a picture link on top of the cell containing the
formula. The cell containing the formula would need to have number format ;;;.

This is quite fragile, but it would do what the OP wants. However, if the OP has
never written any VBA, this would be impractical.
Click to expand...

Hi Harlan
nice idea but I agree with you this is a little bit fragile and
probably not a 'simple' solution for the OP :-)
Frank
 
Back
Top