formatting text/number in a command

  • Thread starter Thread starter mnarvind
  • Start date Start date
M

mnarvind

Hi,

I have been working on a report and it requires capturing data fro
another sheet...

I used this command :

+"The Profit for the year 2003 i
:"&TEXT('Sheet2'!A2,"$#,##0.00);[red]($#,##0.00)")

but the negative numbers are not displayed in red if I use this comman
like Excel does if we format the negative numbers to display in re
using the format cell/number option.

Another problem is that I would like to display some words in Bold
and/or underline/different colours/italics, like for example, in th
above command , if I want to display
"The Profit ......year 2003" i
bold/undeline/italics/colour...what do i do???

PLEASE HELP !!!!!

THANX IS DUE IN ADVANCE!!!

ARVIN
 
You can't change colors or bolding with a formula. You can't bold or color
some words in a string unless the entry is hardcoded in the cell (no
formulas).

You would need to use code to build the result and do the formatting so the
result is hard coded.
 
Back
Top