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
Solved! Go to Solution.
Thank you. Appreciate your help. :)
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.
@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_], '-')
Thank you.