Changing colour of half a cell's text

[JohnnyTightlips]

Folks,

I have a concatentated formula that appears in the cell as such:

12/34 e.g. =formula&"/"&formula

I would like to change the colour of the second formula (34 in the example) to Red for instance.

I have experimented with the Custom Format function with no luck, but that is likely due to my lack of familiarity with how it works

I also tried the TEXT function, inserting "[Red]0" but that not suprisingly didn't change the colour.

Is there a way to do this using Custom Format?

I'm open to a VBA solution but would prefer not

Cheers

 

[GlennUK]

My pleasure.