Format a part of a text working with only value not working with formula result

hi,
i am using below code to format change text color to a particular part of a text, but this code is working with only value (not formula's result0
i want to apply this code to formula result

thank you

Please Login or Register  to view this content.

Hi,

It is not possible to change the colour of part of a formula's result. You would have to replace the formula with its value and then use the code you already have.