Inline formatting!!!

  • Thread starter Thread starter Eqbal Vkilzadeh
  • Start date Start date
E

Eqbal Vkilzadeh

Hi,

Suppose that I have the below formula:

=â€Total of: †& A1 & “phone calls have been made.â€

Now suppose that I want to change the formatting of the value which is
returned by “A1â€, i.e. the color and type. IS it possible? How?

Tnx,
Eqbal
 
You can't change the color with the formula, but you can
change the formatting for number:
="Total of " & TEXT(A1,"#,##0") & " phone calls have been made."

You can format at total to dispaly the information so that you can still
treat the cell as a number Format, cells, custom format
"total of" #,##0 "phone calls have been made "

If you want to change the color of the entire cell use regular cell formatting
Format, cells, ... make changes to font and/or patterns...l
 
Back
Top