• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Set color/style of text in data merge before import

New Here ,
Jun 12, 2024 Jun 12, 2024

Copy link to clipboard

Copied

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?

TOPICS
How to , Import and export , Type

Views

88

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Jun 12, 2024 Jun 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.

Votes

Translate

Translate
Community Expert ,
Jun 12, 2024 Jun 12, 2024

Copy link to clipboard

Copied

LATEST

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines