NOTE Make sure that only one worksheet is selected. But you can easily change every effect in the gallery after you create the WordArt. Unlike in Excel 2003, this gallery offers no twisting effects. It's not exactly what we were looking for, but a good alternative for an impressive, simple and dynamic WordArt effect. In Excel, click the worksheet that you want to display with the watermark. This is a bit perplexing to WordArt veterans. However, since WordArt can't be controlled with normal conditional formatting, I resorted to using a bar-in-bar chart for the line in the percentage sign. Solution 2: Avoid VBA and use Excel Functionality only. Solution 1: Use VBA together with Worksheet Change Event Handler Procedure to make the whole process dynamic. Here are the two solutions I came up with So whenever the percentage value in a specific cell is changed, the WordArt should update to reflect not just the same number, but also its fill color should reflect the percentage amount. Open your Excel sheet, then click the Standard toolbar’s Drawing button or go to View Toolbars and select Drawing. You then see some default text appear in the worksheet. Select a general appearance that you want used for your text, and then click on OK. In the Text group, click the WordArt tool. It should be setup in Excel and updated automatically. To add WordArt to an Excel worksheet in Excel 2007, follow these steps: Display the Insert tab of the ribbon. The challenge was to adjust the fill color of the percentage value to reflect the percentage itself.

How to add word art to excel