 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2007Conditional formatting of a text box ?
I have a cell conditional formatted as red or green depending on the value. I have a text box on another sheet referring to that cell. Can the text box contain the same conditional formatting ? And if so, how do I do it ? Thanks, Steve Hi, First of all there are at least three different kinds of Text boxes - which one do you mean? The one on the Drawing toolbar, the Forms toolbar, or the Control Toolbox? Second, what kind of format is the Conditional Formatting applying? Font Style is passed to the Drawing toolbar textbox for example. Anything else will probably require VBA if it can be done.  SignatureCheers, Shane Devenshire > I have a cell conditional formatted as red or green depending on the value. > I have a text box on another sheet referring to that cell. [quoted text clipped - 4 lines] > > Steve I used the drawing texbox. It refers to another cell on another sheet via the formula bar = 'sheet 1'!D$17, which is conditional formatted to be red if < another cell value, and green if => that same cell value. > Hi, > [quoted text clipped - 15 lines] > > > > Steve Hi Steve, Sorry to take so long but it was a very busy week. Replace the drawing text box with a Camera tool picture of the cell. To add the Camera tool to the toolbar choose View, Toolbars, Customize, Commands tab, Tools catergory and near the bottom of the list on the right side. Select the cell you want to put into the textbox and click the Camera tool, move the the sheet you want the textbox on and click a cell. Then move it around as necessary. SignatureCheers, Shane Devenshire > I used the drawing texbox. > It refers to another cell on another sheet via the formula bar = 'sheet [quoted text clipped - 20 lines] > > > > > > Steve No need to apologize. Perfect solution. I never even knew about the camera. Thanks again, Steve > Hi Steve, > [quoted text clipped - 34 lines] > > > > > > > > Steve One more question just came up. I'm working on a chart, and if any part of the chart is selected, the camera box if hidden/unseen. If I unselect the chart, it becomes visible. Is there any way it stays visible ? Thanks, > Hi Steve, > [quoted text clipped - 34 lines] > > > > > > > > Steve Hi Steve, No. However, if the chart is going to stay in the same location, you can capture it with the Camera tool. First I fit the chart to an exact block of cells you dragging and sizing it with the Alt held down. Then I select the cells behind the chart. Then use the camera tool. There will be a second border around the chart picture but you can single click it and choose Format, Picture and on the Color and Lines tab and under Line, open the Color drop down and choose No line. However if you move or size the original picture you will have interesting problems. SignatureCheers, Shane Devenshire > One more question just came up. > I'm working on a chart, and if any part of the chart is selected, the camera [quoted text clipped - 41 lines] > > > > > > > > > > Steve Shane, Thanks a lot for all your patience and help. It's much appreciated. I think i'll just remember to click properly around the chart to keep it visible. Thanks again, Steve > Hi Steve, > [quoted text clipped - 54 lines] > > > > > > > > > > > > Steve |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.