Skip to main content
Participating Frequently
June 12, 2024
Answered

Set color/style of text in data merge before import

  • June 12, 2024
  • 1 reply
  • 224 views

Is there a way to set the color/style of text (in excel) before exporting for data merge?
For example: I want the word NEW to import as red type BUT the word SAVE to import as black type. 
Or is this something that HAS to be done after exporting the Data Merge in InDesign?

This topic has been closed for replies.
Correct answer Jeffrey_Smith

This kind of styling can be accomplished with predefined GREP styles in the master data merge file.

 

For example, the data file could contain records like SAVE 20%, SAVE 30%, SAVE 40%. The tag for the discount column in data soucre would be applied a paragraph style containing a GREP style. The GREP would apply a character style (with a red character attribute) to make all occurrences of "SAVE" red in appearance.

1 reply

Jeffrey_SmithCommunity ExpertCorrect answer
Community Expert
June 12, 2024

This kind of styling can be accomplished with predefined GREP styles in the master data merge file.

 

For example, the data file could contain records like SAVE 20%, SAVE 30%, SAVE 40%. The tag for the discount column in data soucre would be applied a paragraph style containing a GREP style. The GREP would apply a character style (with a red character attribute) to make all occurrences of "SAVE" red in appearance.