| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bold Text Formatting
Hi Reno,
May be you will find some inspiration in this event module : Private Sub Worksheet_Change(ByVal Target As Range) Set Target = Range("A1") With Target.Characters(Start:=1, Length:=3).Font .ColorIndex = xlAutomatic End With With Target.Characters(Start:=4, Length:=2).Font .ColorIndex = 5 .Bold = True End With End Sub HTH Cheers Carim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting based on text within a formula | Excel Worksheet Functions | |||
| conditional formatting with text | Excel Discussion (Misc queries) | |||
| How do I get selected text within a cell to remain bold in excel? | Excel Discussion (Misc queries) | |||
| Banding with Conditional Formatting with Multiple Conditions | Excel Worksheet Functions | |||
| Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
Hybrid Mode
