If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Text Box
I have created a text box on an Excel 2000 chart linked to
a cell on a work sheet. The cell on the work sheet uses conditional formatting to change the number color to red or green. The text box on the chart will show the new value but not the color. What's wrong? |
#2
|
|||
|
|||
Text Box
nothing's wrong - conditional formatting applies only to cells.
You can get the same effect if you use the Camera tool (Tools/Customize/Commands, drag Camera to a toolbar or menu). Select the cell, take a picture using the camera tool, and paste it into the chart. The picture will show the current contents of the cell, including formatting. In article , "Lloyd Champine" wrote: I have created a text box on an Excel 2000 chart linked to a cell on a work sheet. The cell on the work sheet uses conditional formatting to change the number color to red or green. The text box on the chart will show the new value but not the color. What's wrong? |
#3
|
|||
|
|||
Text Box
Or to avoid messing with tool bar: hold down Shift before using menu's Edit
item and locate Copy Picture. Bernard "J.E. McGimpsey" wrote in message ... nothing's wrong - conditional formatting applies only to cells. You can get the same effect if you use the Camera tool (Tools/Customize/Commands, drag Camera to a toolbar or menu). Select the cell, take a picture using the camera tool, and paste it into the chart. The picture will show the current contents of the cell, including formatting. In article , "Lloyd Champine" wrote: I have created a text box on an Excel 2000 chart linked to a cell on a work sheet. The cell on the work sheet uses conditional formatting to change the number color to red or green. The text box on the chart will show the new value but not the color. What's wrong? |
Thread Tools | |
Display Modes | |
|
|