Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formatting text/number in a command
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 -- mnarvin ----------------------------------------------------------------------- mnarvind's Profile: http://www.excelforum.com/member.php...fo&userid=1520 View this thread: http://www.excelforum.com/showthread.php?threadid=26839 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formatting text/number in a command
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Formatting Number as Text | Excel Worksheet Functions | |||
Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
Formatting from Number to Text | Excel Discussion (Misc queries) | |||
Formatting Number as Text | Excel Programming | |||
Formatting Number as Text | Excel Programming |