The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

Alteryx Designer Desktop Discussions

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

FORMAT AN EXCEL COLUMN

ABC_Anonymous
7 - Meteor

hello, I wanted to know how I can format an excel column by group as mentioned in the screenshot

 

Thanks for your support

USE CASE COMMUNITY PRBLM.png

3 REPLIES 3
Raj
16 - Nebula

@ABC_Anonymous 
what is the condition to decide the color?

ABC_Anonymous
7 - Meteor

 these are percentages, i.e. if it is at 100% it becomes red, otherwise it gradates towards green. (but in the screenshot if it's over 2% it turns red)

Raj
16 - Nebula

@ABC_Anonymous 
you can create multiple conditions based on logic
sample is attached below

Labels
Top Solution Authors