How to color specific text within a cell

[winiarc]

Hi, I am looking for a way to color specific text within a cell, my data within the cell looks something like this:

xyz RED xyz xyz xyz

xyz xyz xyz GREEN

I want the word 'red' to be colored red,  the word 'green' to be colored green, etc.

I keep trying row / column rules within the table tool but can't get the desired effect.

Any help appreciated, thank you

[Qiu]

@winiarc 
I think we can color the cell, but not the different colors in one Cell.

[winiarc]

I'm pretty sure it's possible using a formula within the table tool, I just can't find the exact way to do this..

[Qiu]

@winiarc 
I have replied something for the whole cell but not for part of the cell.
I would love to see how it can be achieved.
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Formatting-Row-rule-in-Basic-T...

[binuacs · Accepted solution]

@winiarc One way of doing this

[winiarc]

Hi, thank you, so this works well!

I do have a subsequent issue though which is the line breaks I have within the cells get removed when I use this method, I am guessing it's the table tool itself that does that

[binuacs]

@winiarc That is correct, the table tool replaces the new line characters, there are workaround to replace the new line character with <b \>

[winiarc]

Can you elaborate please, how would I do that exactly ?