#Edit Text Boxes In Excel 2008 Mac MVP Bob

Answer: If you wish to change the color of the font based on the value in a cell, you will need to apply conditional formatting. To do this, select the cell that you wish to apply the formatting to. In this example, we've selected cell B8. Select the Home tab in the toolbar at the top of the screen. Then click on the Conditional Formatting drop.

Edit Text Boxes In Excel 2008 Mac MVP Bob

Once on the tab, every command on the Ribbon will have a number or letter beside it. SP3 Windows Server 2008 R2 Windows Server 2008 Windows Server 2003 Mac OS.Mac MVP Bob Jones recommends the following solution: If your chart is on a chart sheet, you need to click somewhere in the chart. The Text Box tool will then be available on the Drawing Toolbar. You'll also be able to select any of the shapes in the AutoShapes palette of the same bar or the Object Palette of the Toolbox & add text to them.1) Click on a single cell, a Row button, or a Column button (or click & drag over a number of cells) where you want to change the formatting. 2) Click on Format.Once you have the program open and are ready to perform this technique, just press the Alt key and the letter N at the same time, then let go of those keys and press the letter X. ThatвЂ™s it! YouвЂ™re ready to draw your text box.

YouвЂ™ll have to modify the instructions, of course, to match the program youвЂ™re using, but itвЂ™s a pretty simple techniqueвЂ”the macro program will be used to send a Control-U to Excel when you press F2.To do this in Butler, select Butler -> Customize from ButlerвЂ™s menu, and then make sure youвЂ™re on the Configuration tab. With a bit of help from a third-party program, though, you can achieve the same end resultвЂ”make F2 edit the current cell in Excel (2004 or 2008) on the Mac.To make this work, youвЂ™ll need some sort of program that supports macros IвЂ™m going to use Butler, but you should be able to use iKey, Keyboard Maestro, or QuicKeys, or any similar program. Unfortunately, you wonвЂ™t find the вЂњedit this cellвЂќ command listed in ExcelвЂ™s keyboard customization section, so thereвЂ™s no apparent way to change the shortcut. YouвЂ™ll probably find quite a few that you didnвЂ™t know about.) After many years of using a PC in my prior job, I found the Control-U shortcut not only hard to remember, but harder to type.

Select Smart Item -> Keystrokes, which will add a new macro entry in the Hidden section.

Edit Text Boxes In Excel 2008 For Mac