Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

how to color different cell based on specified condition

Rajeev18
8 - Asteroid

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

NameAttending meeting
AYes
bYes
cNo
dMay be
eNo


Regards,

Rajeev

6 REPLIES 6
Thableaus
17 - Castor
17 - Castor

Hi @Rajeev18 

 

See WF attached.

 

ColumnRules.PNG

 

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

 

Cheers,

Rajeev18
8 - Asteroid

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
15 - Aurora
15 - Aurora

Hi @Rajeev18,

 

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

 

image.png

 

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
8 - Asteroid

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 IDProduct Name1st level Approval statusDate2nd level Approval statusDate
12345MIn Transmit12/13/19Submitted12/13/19
23456NIn Transmit10/19/19Submitted10/19/19
98766ZAccepted12/13/19Not sent12/13/19
45678AAccepted11/25/19Accepted11/25/19
32156BRejected12/13/19Rejected12/13/19
23457CWIP10/29/19In Transmit10/29/19
45678WSubmitted12/11/19In Transmit12/11/19
12980XAccepted12/11/19Accepted12/11/19
45987YRejected12/01/19Submitted12/01/19
345678ZMay get Rejected12/11/19Accepted12/11/19
234568QIn Issue10/27/19Submitted10/27/19
98765sAccepted12/13/19In Transmit12/13/19

 

File 2: -

Product IDProduct Name1st level Approval statusDate2nd level Approval statusDate
12345MIn Transmit12/13/19Submitted12/13/19
23456NIn Transmit10/19/19Submitted10/19/19
98766ZAccepted12/13/19In Issue12/13/19
45678AAccepted11/25/19Accepted11/25/19
32156BRejected12/13/19Rejected12/13/19
23457CRejected10/29/19May get Rejected10/29/19
45678WSubmitted12/11/19In Transmit12/11/19
12980XAccepted12/11/19Accepted12/11/19
45987YRejected12/01/19Submitted12/01/19
345678ZMay get Rejected12/11/19Accepted12/11/19
234568QIn Issue10/27/19Submitted10/27/19
98765sAccepted12/13/19In Transmit12/13/19

 

File 3:- 

Product IDProduct Name1st level Approval statusDate2nd level Approval statusDate
12345MIn Transmit12/13/19Submitted12/13/19
23456NIn Transmit10/19/19Submitted10/19/19
98766ZAccepted12/13/19In Issue12/13/19
45678AAccepted11/25/19Accepted11/25/19
32156BRejected12/13/19Rejected12/13/19
23457CRejected10/29/19May get Rejected10/29/19
45678WSubmitted12/11/19In Transmit12/11/19
12980XAccepted12/11/19Accepted12/11/19
45987YRejected12/01/19Submitted12/01/19
345678ZMay get Rejected12/11/19Accepted12/11/19
234568QIn Issue10/27/19Submitted10/27/19
98765sAccepted12/13/19In Transmit12/13/19

 

OUTPUT File Required:- 

Rajeev18_0-1577966383378.png






Rajeev18
8 - Asteroid

@Jonathan-Sherman @Thableaus 

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

Jonathan-Sherman
15 - Aurora
15 - Aurora

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

Labels