Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

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
‎09-24-2024 01:10 AM

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

 

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

3 REPLIES 3
Raj
16 - Nebula
‎09-24-2024 01:13 AM

@ABC_Anonymous 
what is the condition to decide the color?

Reply
0 Likes
ABC_Anonymous
7 - Meteor
‎09-24-2024 01:17 AM

 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)

Reply
0 Likes
Raj
16 - Nebula
‎09-24-2024 01:40 AM

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

4060.yxmd
Reply
GenAI Contest Form
License admin COmmunity Live
Labels
Top Solution Authors
View All