Automatically assign block colour to appropriate list item.

Question

I'm a musician and like printing the list of songs we play on a big sheet of paper for each performance.

In front of each song, I place a block with a colour (either red or green) to indicate which pedals I need to use. Sometimes also a symbol for the 'tone'.

Is there a way to create these lists automatically? For example, creating or selecting the list of songs in Excel in a particular order, click a button, and have a PDF generated through InDesign with the appropriate colour blocks and/or symbols in front of each song.

Attached an example of a general setlist.

Any tips would be of great help!!!
Thank you.
-Dan

Laubender · Accepted Answer

Hi Dan,to automate this you can use GREP styles with the applied paragraph style.Your Excel file could provide the right "pattern" for "green" or "red" or no color.For example "G" for green and "R" for red and no entry for no color.Your paragraph style will react on this. The GREP pattern for start a paragraph with G is: ^G The applied character style will provide the right formatting:No fill for the character, a strike-through colored in green, Courier New for the font because you need the G and the R in the same width, maybe also change the width of the character a bit. That's all. Screenshots from my German InDesign below.Text frame on top, no special formatting, just how the contents is typed.Frame in the middle: character styles applied directly to the first character in the paragraphs.Frame at the bottom: Paragraph style reacts on the contents and applies automatically character style G to character G and character style R to character R:  Applied paragraph style to all paragraphs at the frame on the bottom: Download that sample document from my Dropbox account:https://www.dropbox.com/s/54rdhs6bebkm7wz/ListWithColoredBulletPoint-2022.indd?dl=1 Regards,Uwe Laubender( Adobe Community Professional )

jmlevy · Answer

You can create lists beginning automatically with a red or green (or every color you want) square (or circle, or triangle, what you want), using paragraph styles.

https://helpx.adobe.com/indesign/using/bullets-numbering.html#:~:text=Format%20a%20bulleted%20or%20numbered%20list

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.