title: Format a subset of text in Excel Cell Using Formula
body: <p>I Have built a string using a formula in excel.  as an example </p>
  
  <blockquote>
    <p>Cell C3 contains text  "Languages"<br>
    Cell C4 = "English, Spanish,German, French"<br>
    My Forumla = C3 &amp; ":" &amp; CHAR(10) &amp; C4</p>
  </blockquote>
  
  <p>The Desired text would be:</p>
  
  <blockquote>
    <p>Languages:<br>
    <strong>English, Spanish, German, French</strong></p>
  </blockquote>
  
  <p>(where the bold text would actually be some color like red)</p>
  
  <p>Is there a way to do this in Excel (change partial text formatting) . </p>
  
  <p>I Have tried a formula... (Not working)</p>
  
  <pre><code>Function formatText(InText As Range)
  
  'Set font color
    InText.Characters(1.5).Font.Color = Red
     'InText.Characters((InStr(1, ":", InText) + 1), (Len(InText) - InStr(1, ":", InText))).Font.ColorIndex = 3
  End Function
  </code></pre>