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

Workflow

Accepted answers

binu_acs

@winiarc One way of doing this

Color_Specific_Text_210224.yxmd

All comments

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-Table/m-p/1206659#M299372

binu_acs

@winiarc One way of doing this

Color_Specific_Text_210224.yxmd

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703