FORMAT AN EXCEL COLUMN

[ABC_Anonymous]

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

Thanks for your support

 

[Raj]

@ABC_Anonymous 
what is the condition to decide the color?

[ABC_Anonymous]

 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 · Accepted solution]

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