| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Formating textbox on a chart
I have a dollar amount created with the formula
=IF(NewProfit<0,"$"&FIXED(-NewProfit,-2),"$"&FIXED(NewProfit,-2)) in an Excel spreadsheet which is linked to a textbox on a chart. I would like to format the numbers in the chart 1) Bold and 2) Blue when positive and Red when negative. Any suggestion would be greatly appreciated, Roger |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Formating textbox on a chart
You can just select the textbox and select Bold.
You don't need the IF to get conditional formatting or your dollar format. The cell just needs this formula =ROUND(NewProfit,-2) (FIXED results in text, not a number) and a custom number format of [blue]$#,##0;[red]$-#,##0;$0;@ Link the textbox to the cell, and apply the same number format to the textbox. More on number formats: http://peltiertech.com/Excel/NumberFormats.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Roger B." wrote in message ... I have a dollar amount created with the formula =IF(NewProfit<0,"$"&FIXED(-NewProfit,-2),"$"&FIXED(NewProfit,-2)) in an Excel spreadsheet which is linked to a textbox on a chart. I would like to format the numbers in the chart 1) Bold and 2) Blue when positive and Red when negative. Any suggestion would be greatly appreciated, Roger |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Formating textbox on a chart
Jon, thanks so much for your update. It was very helpful. There is only
one problem: I can't get the "Format Cells, Number" when working in the TextBox. Instead I get "Format TextBox" but can't find the numbers. Also looked at your website but couldn't find the cure. Any suggestions would be very helpful. Thanks, Roger "Jon Peltier" wrote in message ... You can just select the textbox and select Bold. You don't need the IF to get conditional formatting or your dollar format. The cell just needs this formula =ROUND(NewProfit,-2) (FIXED results in text, not a number) and a custom number format of [blue]$#,##0;[red]$-#,##0;$0;@ Link the textbox to the cell, and apply the same number format to the textbox. More on number formats: http://peltiertech.com/Excel/NumberFormats.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Roger B." wrote in message ... I have a dollar amount created with the formula =IF(NewProfit<0,"$"&FIXED(-NewProfit,-2),"$"&FIXED(NewProfit,-2)) in an Excel spreadsheet which is linked to a textbox on a chart. I would like to format the numbers in the chart 1) Bold and 2) Blue when positive and Red when negative. Any suggestion would be greatly appreciated, Roger |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Formating textbox on a chart
Hi,
I think maybe Jon was think of a data label, which does have a number format. For textboxes I think you will need to use 2 of everything. 2 formula to display the result positive =IF(ROUND(NewProfit,-2)=0,ROUND(NewProfit,-2),"") negative =IF(ROUND(NewProfit,-2)<0,ROUND(NewProfit,-2),"") and 2 textboxes with the correct formatting applied. Cheers Andy Roger B. wrote: Jon, thanks so much for your update. It was very helpful. There is only one problem: I can't get the "Format Cells, Number" when working in the TextBox. Instead I get "Format TextBox" but can't find the numbers. Also looked at your website but couldn't find the cure. Any suggestions would be very helpful. Thanks, Roger "Jon Peltier" wrote in message ... You can just select the textbox and select Bold. You don't need the IF to get conditional formatting or your dollar format. The cell just needs this formula =ROUND(NewProfit,-2) (FIXED results in text, not a number) and a custom number format of [blue]$#,##0;[red]$-#,##0;$0;@ Link the textbox to the cell, and apply the same number format to the textbox. More on number formats: http://peltiertech.com/Excel/NumberFormats.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Roger B." wrote in message .. . I have a dollar amount created with the formula =IF(NewProfit<0,"$"&FIXED(-NewProfit,-2),"$"&FIXED(NewProfit,-2)) in an Excel spreadsheet which is linked to a textbox on a chart. I would like to format the numbers in the chart 1) Bold and 2) Blue when positive and Red when negative. Any suggestion would be greatly appreciated, Roger -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Formating textbox on a chart
Sorry. I was thinking of textboxes, but I wasn't testing, just typing.
Otherwise I'd have noticed the lack of number formatting in a text box. My Bad. Jon Peltier, Microsoft Excel MVP http://PeltierTech.com "Andy Pope" wrote in message ... Hi, I think maybe Jon was think of a data label, which does have a number format. For textboxes I think you will need to use 2 of everything. 2 formula to display the result positive =IF(ROUND(NewProfit,-2)=0,ROUND(NewProfit,-2),"") negative =IF(ROUND(NewProfit,-2)<0,ROUND(NewProfit,-2),"") and 2 textboxes with the correct formatting applied. Cheers Andy Roger B. wrote: Jon, thanks so much for your update. It was very helpful. There is only one problem: I can't get the "Format Cells, Number" when working in the TextBox. Instead I get "Format TextBox" but can't find the numbers. Also looked at your website but couldn't find the cure. Any suggestions would be very helpful. Thanks, Roger "Jon Peltier" wrote in message ... You can just select the textbox and select Bold. You don't need the IF to get conditional formatting or your dollar format. The cell just needs this formula =ROUND(NewProfit,-2) (FIXED results in text, not a number) and a custom number format of [blue]$#,##0;[red]$-#,##0;$0;@ Link the textbox to the cell, and apply the same number format to the textbox. More on number formats: http://peltiertech.com/Excel/NumberFormats.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Roger B." wrote in message . .. I have a dollar amount created with the formula =IF(NewProfit<0,"$"&FIXED(-NewProfit,-2),"$"&FIXED(NewProfit,-2)) in an Excel spreadsheet which is linked to a textbox on a chart. I would like to format the numbers in the chart 1) Bold and 2) Blue when positive and Red when negative. Any suggestion would be greatly appreciated, Roger -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Formating textbox on a chart
Jon, am not sure of your conclusion. Is there any way of connecting the
Textbox to the spreadsheet with the colours showing in the Textbox? Thanks, Roger "Jon Peltier" wrote in message ... Sorry. I was thinking of textboxes, but I wasn't testing, just typing. Otherwise I'd have noticed the lack of number formatting in a text box. My Bad. Jon Peltier, Microsoft Excel MVP http://PeltierTech.com "Andy Pope" wrote in message ... Hi, I think maybe Jon was think of a data label, which does have a number format. For textboxes I think you will need to use 2 of everything. 2 formula to display the result positive =IF(ROUND(NewProfit,-2)=0,ROUND(NewProfit,-2),"") negative =IF(ROUND(NewProfit,-2)<0,ROUND(NewProfit,-2),"") and 2 textboxes with the correct formatting applied. Cheers Andy Roger B. wrote: Jon, thanks so much for your update. It was very helpful. There is only one problem: I can't get the "Format Cells, Number" when working in the TextBox. Instead I get "Format TextBox" but can't find the numbers. Also looked at your website but couldn't find the cure. Any suggestions would be very helpful. Thanks, Roger "Jon Peltier" wrote in message ... You can just select the textbox and select Bold. You don't need the IF to get conditional formatting or your dollar format. The cell just needs this formula =ROUND(NewProfit,-2) (FIXED results in text, not a number) and a custom number format of [blue]$#,##0;[red]$-#,##0;$0;@ Link the textbox to the cell, and apply the same number format to the textbox. More on number formats: http://peltiertech.com/Excel/NumberFormats.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Roger B." wrote in message .. . I have a dollar amount created with the formula =IF(NewProfit<0,"$"&FIXED(-NewProfit,-2),"$"&FIXED(NewProfit,-2)) in an Excel spreadsheet which is linked to a textbox on a chart. I would like to format the numbers in the chart 1) Bold and 2) Blue when positive and Red when negative. Any suggestion would be greatly appreciated, Roger -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Road map with Chart Conditional Formating | Charts and Charting in Excel | |||
| Activating a Chart object | Charts and Charting in Excel | |||
| Urgent Chart Assistance | Charts and Charting in Excel | |||
| Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
| manipulating textbox in chart | Charts and Charting in Excel | |||
Hybrid Mode
