Formatting Question

  • Thread starter Thread starter M. Johnson
  • Start date Start date
M

M. Johnson

Is it possible to format only part of a cell to be bold? I have a cell that
I want to say:

Week Start: 09-19-2004

and I have the cell set up to display "Week Start: " through the cell
properties, but I want that to be bold. Any ideas?
 
Hi,

You might get your result with some code:

Assuming the data is in cell A1, this code will make the "Week Start:
bold and red (colour 3) and the remaining "9-19-2004" regular.

Alter the code to check other cells if needed.

Range("A1").Select
ActiveCell.FormulaR1C1 = "Week Start: 09-19-2004"
With ActiveCell.Characters(Start:=1, Length:=11).Font
.FontStyle = "Bold"
.ColorIndex = 3
End With
With ActiveCell.Characters(Start:=12, Length:=11).Font
.FontStyle = "Regular"
.ColorIndex = xlAutomatic
End With

End Sub

Hope this helps
Koal
 
You can do partial cells with bold if it is only text. Just select th
part you want bold inside the cell. And select Bold.

You cannot however do it if it is part of a formula
 
Back
Top