| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Parts of Formulas
OK. Thanks for your help!
"Ron Rosenfeld" wrote: On Thu, 21 Sep 2006 04:59:02 -0700, cogorman wrote: I've created a formula that includes text and also variables from other cells. Is it possible to format different parts of the formula differently, e.g. bold some of it? For example: ="Beginning of sentence "&TEXT($D$26,"$##,####.00") I would like to be able to make the data brought in from D26 bold. It is not possible if there is a formula in the cell. It is possible if the cell is only a text string. You can use VBA to either change the cell to it's equivalent text string, or copy it elsewhere; and then, within the VBA sub, change the format of the selected characters. In your instance, something like: ======================================== Option Explicit Sub BoldPart() Dim rDest As Range Dim sStart As String Dim sD26 As Variant Dim sEnd As String Set rDest = Range("A1") sStart = "Beginning of sentence " sD26 = Range("D26").Value sEnd = Format(sD26, "$##,####.00") Application.ScreenUpdating = False rDest.Value = sStart & sEnd rDest.Characters(Len(sStart) + 1, Len(sEnd)).Font.Bold = True Application.ScreenUpdating = True End Sub ================================ There's a lot of redundancy for clarity. Clearly you'll have to modify it to suit your requirements. One thing you might want to add is error checking that the contents of D26 are numeric. --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting for Formulas | Excel Discussion (Misc queries) | |||
| Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
| Excel formulas / formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting Error | Excel Worksheet Functions | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
