how to color different cell based on specified condition

[Rajeev18]

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

[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,

[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 · Accepted solution]

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

[Rajeev18]

Hello @Thableaus  @Jonathan-Sherman 

Please help me to find how to get 3 different output file with 3 different Input file in one excel workbook based on certain condition.

Example:- 
File- 1

Product ID	Product Name	1st level Approval status	Date	2nd level Approval status	Date
12345	M	In Transmit	12/13/19	Submitted	12/13/19
23456	N	In Transmit	10/19/19	Submitted	10/19/19
98766	Z	Accepted	12/13/19	Not sent	12/13/19
45678	A	Accepted	11/25/19	Accepted	11/25/19
32156	B	Rejected	12/13/19	Rejected	12/13/19
23457	C	WIP	10/29/19	In Transmit	10/29/19
45678	W	Submitted	12/11/19	In Transmit	12/11/19
12980	X	Accepted	12/11/19	Accepted	12/11/19
45987	Y	Rejected	12/01/19	Submitted	12/01/19
345678	Z	May get Rejected	12/11/19	Accepted	12/11/19
234568	Q	In Issue	10/27/19	Submitted	10/27/19
98765	s	Accepted	12/13/19	In Transmit	12/13/19

File 2: -

Product ID	Product Name	1st level Approval status	Date	2nd level Approval status	Date
12345	M	In Transmit	12/13/19	Submitted	12/13/19
23456	N	In Transmit	10/19/19	Submitted	10/19/19
98766	Z	Accepted	12/13/19	In Issue	12/13/19
45678	A	Accepted	11/25/19	Accepted	11/25/19
32156	B	Rejected	12/13/19	Rejected	12/13/19
23457	C	Rejected	10/29/19	May get Rejected	10/29/19
45678	W	Submitted	12/11/19	In Transmit	12/11/19
12980	X	Accepted	12/11/19	Accepted	12/11/19
45987	Y	Rejected	12/01/19	Submitted	12/01/19
345678	Z	May get Rejected	12/11/19	Accepted	12/11/19
234568	Q	In Issue	10/27/19	Submitted	10/27/19
98765	s	Accepted	12/13/19	In Transmit	12/13/19

File 3:- 

Product ID	Product Name	1st level Approval status	Date	2nd level Approval status	Date
12345	M	In Transmit	12/13/19	Submitted	12/13/19
23456	N	In Transmit	10/19/19	Submitted	10/19/19
98766	Z	Accepted	12/13/19	In Issue	12/13/19
45678	A	Accepted	11/25/19	Accepted	11/25/19
32156	B	Rejected	12/13/19	Rejected	12/13/19
23457	C	Rejected	10/29/19	May get Rejected	10/29/19
45678	W	Submitted	12/11/19	In Transmit	12/11/19
12980	X	Accepted	12/11/19	Accepted	12/11/19
45987	Y	Rejected	12/01/19	Submitted	12/01/19
345678	Z	May get Rejected	12/11/19	Accepted	12/11/19
234568	Q	In Issue	10/27/19	Submitted	10/27/19
98765	s	Accepted	12/13/19	In Transmit	12/13/19

OUTPUT File Required:- 

[Rajeev18]

@Jonathan-Sherman @Thableaus 

In Transmit  -Yellow
Accepted - Green
Rejected, May get Rejected & In Issue -  Red

[Jonathan-Sherman]

Hi @Rajeev18,

You cannot colour cells in excel using an alteryx workflow as the cell colour conditioning is calculated from within excel locally. It would need to be exported as a PDF or image through the reporting tools.

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan