Color format only part of a string?

[LD1010]

Thanks for reading my post.

Is there a way to format a text string so that anything following the >(greater than) charater would be formate Red?

Any help would be appreciated.

 

[ClydeData]

This could be done with 2 adjacent text boxes

In the left hand box have your mathematical operator as the result of an If Then Else statement

On the right hand text box have the value

Then use conditional formating on the left hand box
EG > = red
<= blue or whatever

Cheers

Jimmy