SOLVED
FORMAT AN EXCEL COLUMN
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ABC_Anonymous
6 - Meteoroid
09-24-2024
01:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hello, I wanted to know how I can format an excel column by group as mentioned in the screenshot
Thanks for your support
Solved! Go to Solution.
Labels:
- Labels:
- Reporting
3 REPLIES 3
Raj
16 - Nebula
09-24-2024
01:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ABC_Anonymous
what is the condition to decide the color?
09-24-2024
01:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
09-24-2024
01:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ABC_Anonymous
you can create multiple conditions based on logic
sample is attached below
