Is it possible to display part of the cell in bold font?

[Rnkhch]

Hello,

I join a series of two cells together with a slash in between, such that the cell shows the two numbers as a fraction, such as below:

C1=A1&"/"&B1

I'm wondering if it's possible to have the numerator be displayed in bold font, while the slash and the denominator are in regular font (and ideally grayed out if possible).

Thanks a lot for any input.

 

[Rick Rothstein]

No, you cannot format parts of a value returned by a formula differently than other parts of that return value... you can only do such different formatting if the cell contains a text constant. It would be possible to do what you asked if you remove the formula from the cell(s) and use a Change event procedure to produce the same output that the formula would produce. Are you interested and able to use VBA code in your workbook?

 

[Michael M]

I don't believe you can modify the result of a formula....unless it can be done programatically.

 

[footoo]

Hello,

I join a series of two cells together with a slash in between, such that the cell shows the two numbers as a fraction, such as below:

C1=A1&"/"&B1

I'm wondering if it's possible to have the numerator be displayed in bold font, while the slash and the denominator are in regular font (and ideally grayed out if possible).

Thanks a lot for any input.

https://www.mrexcel.com/forum/excel...old-within-formula-vlookup-another-sheet.html

 

[Rnkhch]

No, you cannot format parts of a value returned by a formula differently than other parts of that return value... you can only do such different formatting if the cell contains a text constant. It would be possible to do what you asked if you remove the formula from the cell(s) and use a Change event procedure to produce the same output that the formula would produce. Are you interested and able to use VBA code in your workbook?

Thank you Rick, yes please post the VBA solution if you get a chance. I'm able to use VBA at very basic level. Usually, I copy/paste the entire sheet as number to get rid of the formulas, so the sheet now contains no formulas and is just text string.

 

[Peter_SSs]

For cells in column C, assuming the conversion to just text has already happened, try this.
If the conversion from formula has not already happened, uncomment the green line.

Sub PartialFormat()
  Dim c As Range
  Dim pos As Long
  
  For Each c In Range("C1", Range("C" & Rows.Count).End(xlUp))
    pos = InStr(1, c.Value, "/")
    If pos > 0 Then
      'c.Value = c.Value
      c.Font.ColorIndex = 15
      With c.Characters(Start:=1, Length:=pos - 1).Font
        .Color = vbBlack
        .Bold = True
      End With
    End If
  Next c
End Sub
End Sub

 

[Rnkhch]

Thanks a lot Peter You're the absolute number one

 

[Peter_SSs]

Thanks a lot Peter

You're welcome. Glad it worked for you.