how to color different cell based on specified condition

Hello,

I want my table column with different color based on the condition .

Example- If attending meeting column has data Yes, No or Maybe, how to have different color for all the response.
Yes =Yellow
No = Red
May be =Blue

Name	Attending meeting
A	Yes
b	Yes
c	No
d	May be
e	No

Regards,

Rajeev

Workflow

Accepted answers

Jonathan-Sherman

Hi @Rajeev18,

I've build a little further on @Thableaus solution to create the multiple words colour conditioning:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20191201 - CellColourConditioning.yxmd

All comments

Thableaus

Hi @Rajeev18

See WF attached.

PS: I put "May be" but you can change to "maybe" if you want in the Table Tool configuration rules.

Cheers,

ColumnRules.yxmd

Rajeev18

Hello @Thableaus

Thank you so much for the quick Solution. It worked.

I have one more condition to apply, that is - if any cell contains few words then there should be different color.

Could you please help me on this as well.

Regards,

Rajeev

Jonathan-Sherman

Hi @Rajeev18,

I've build a little further on @Thableaus solution to create the multiple words colour conditioning:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20191201 - CellColourConditioning.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703