|As noted in the thread you linked to, as well as this more recent one, you cannot apply rich text formatting to text within a cell if that text was the result of a formula. |
Since the "text" isn't really in the cell (the formula is) there is no text for Excel or VBA to format. The standard workaround is to use the formula in one cell and then use VBA to place the value of that formula as text in a different cell. VBA can then format characters within that cell.
If you think that that will work for you, we would need to know how to trigger the VBA to run, either through a manual means (click a button, etc) or via the Worksheet_Change event as done in the code offered at the link you provided.
If you want to post the file to a filesharing site and then post the link back here, we can take a look at it. zippyshare.com is a decent site to use. Please do not use a site that will ask us to register, because odds are that we won't.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03