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.

--
Regards,
Tom Ogilvy

"mnarvind" wrote in message
...

Hi,

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

I used this command :

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

but the negative numbers are not displayed in red if I use this command
like Excel does if we format the negative numbers to display in red
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 the
above command , if I want to display
"The Profit ......year 2003" in
bold/undeline/italics/colour...what do i do???

PLEASE HELP !!!!!

THANX IS DUE IN ADVANCE!!!

ARVIND


--
mnarvind
------------------------------------------------------------------------
mnarvind's Profile:
http://www.excelforum.com/member.php...o&userid=15205
View this thread: http://www.excelforum.com/showthread...hreadid=268391