Forum Discussion
Creating a list from selected cells more easily
Hi, I have a list of exercises for my clients. Each client has different exercises and the order is different for every person. I would like to create a list from the exercises that I select. At...
life-work-balance Hi there
I'm sure you could get this to work based on color formatting, but I'd suggest something with a helper column. You'd mark X in the helper column for what you want to include. Then you can use conditional formatting based on that column to mark the cells green if you want.
For the concatenated list, it's a nested IF within a TEXTJOIN.
| Selected | EXERCISE | STATUS |
| (green = good, yellow = untested, blank = untried) | ||
| X | Core exercise A | |
| Core exercise B | ||
| Core exercise C | ||
| X | Arm exercise A | |
| Arm exercise B | ||
| Arm exercise C | ||
| Leg exercise A | ||
| X | Leg exercise B | |
| X | Leg exercise C | |
| Breathing exercise A | ||
| Output: | Core exercise A, Arm exercise A, Leg exercise B, Leg exercise C |
Output: =TEXTJOIN(", ",TRUE,(IF($A$3:$A$12="X",$B$3:$B$12,"")))
Conditional formatting for cell C3: =A3="X" (then set the background color to green, it will shade column C when you put an X in column A
Hi ryanbackerman ,
That looks nice and simple. the Output is working well.
For some reason I can't get the conditional formatting to work though.
My settings:
Apply to range
C3:C12
Rule Type
Highlight cells with
Specific text
Containing
=A3="X"
Format with Green Fill