Alteryx Designer Desktop Discussions

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

Is it possible to color red all negative value in () in output .SLSX

Kinetic_analytics
11 - Bolide

Hello:

Good morning. I have a question. I want to mark all negative value in () as red in output. How can I achieve that?

1,061
(9,290)
(415)
9,696
(429,731)
(234,784)
(1,405)
(10,010)
(1,243,164)

Appreciate your time and efforts. 

Thanks

5 REPLIES 5
MilindG
12 - Quasar

MilindG_0-1666364192825.pngMilindG_1-1666364213944.png

 

Kinetic_analytics
11 - Bolide

Thank you. Appreciate your help. :)

Kinetic_analytics
11 - Bolide

Hello @MilindG  I really appreciate your help on text color into red question. Do you mind to share me the workflow? I am facing difficulties to see details on the Screenshot. Another question is what if in the excel instead of () if the symbol is is given? Appreciate your responses. 

MilindG
12 - Quasar

@Kinetic_analytics  Okay I have attached the workflow. Not too sure about the excel however in Alteryx, you can try the where I have the formula Contains([_CurrentField_], '('), you can change that to Contains([_CurrentField_], '-')

Kinetic_analytics
11 - Bolide

Thank you. 

Labels