Skip to main content
K
KuriousKatie
Known Participant
August 2, 2022
Answered

Conditional Formatting to shapes from CSV text

  • August 2, 2022
  • 4 replies
  • 2017 views

Hi all!

 

I wonder if you can help me?

I'm trying to find a way of changing the colour of shapes in inDesign based on what text it contains. I want each shape to be Green if it contains "safe", and red if it contains "unsafe". 

 

I know inDesign doesn't support native conditional formatting, so I thought a script would be the best way forward?

 

I'm running CC2022, if that makes any difference 🙂

 

If someone could help me with that, I'd really appreciate the help! 🙂

This topic has been closed for replies.
Correct answer Laubender

Hi @KuriousKatie ,

if the shapes were text frames that contain the words "safe" or "unsafe" you could do this with GREP Find/Change and apply a certain paragraph style that is formatted with Paragraph Shading with a huge offset that will be cut to the text frame's edges.

 

GREP Find pattern could be:

^safe\Z

Change to paragraph style "Safe" with that paragraph shading with color "Green".

 

GREP Find pattern could be:

^unsafe\Z

Change to paragraph style "Unsafe" with that paragraph shading with color "Green".

 

From my German InDesign 2022:

 

After the change some text selected where the new paragraph style is applied:

 

 

Note:

Unfortunately you cannot do this with a GREP Style, because an applied character styles's formatting like underline cannot be restricted to the shape of the text frame.

 

Download my test document from my Dropbox account and look into the paragraph styles:

https://www.dropbox.com/s/8a48qhs54vpvq3z/ConditionalFormattingShapes-GREP-FindChange-2022.indd?dl=1

 

Hm, but hold on, you said:

"The words will be within text paths inside of the shapes."

 

If the text path (or better a text frame) is pasted inside another shape you could apply a paragraph style with some GREP Styles and the applied underline stroke of the GREP Styles will be restricted by the path of the outer shape!

 

See page 2 of my test file where I pasted a text frame inside the shape that either contains the word "safe" or "unsafe".

The applied paragraph style has two GREP Styles that apply either character style "Safe" or character style "Unsafe" depending on the contents of the frame. Make sure that the text frame is as wide as the shape or wider; I have set the justification of the paragraph to Full Justified so that the applied underline is as wide as the text frame.

 

On page 2 we have a graphic frame that contains a text frame with the word "safe":

 

Below the text frame outside of the shape to show the formatting of its text:

 

The character style "Safe":

 

The GREP Styles of the applied paragraph style:

 

So I think, you'll find your solution on page 2 of my test document.

 

Regards,
Uwe Laubender
( Adobe Community Professional )

4 replies

K
KuriousKatieAuthor
Known Participant
August 10, 2022

I have another query, if anyone can help me? 🙂

 

Is there any way in inDesign to show/hide certain specified elements on the page, if a certain word in one element is present?

L
Laubender
Brainiac
August 17, 2022

See threads listed below:

 

Show/Hide certain elements on page, when certain text is visible in specified area
KuriousKatie, Aug 10, 2022

https://community.adobe.com/t5/indesign-discussions/show-hide-a-group-of-items-based-on-whether-a-word-from-a-data-merge-is-present-in-that-group/td-p/13138760

 

Nearly same title, different thread:

Show/Hide a group of items based on whether a word from a data merge is present in that group.
KuriousKatie, Aug 16, 2022

https://community.adobe.com/t5/indesign-discussions/show-hide-a-group-of-items-based-on-whether-a-word-from-a-data-merge-is-present-in-that-group/td-p/13138760

 

Regards,
Uwe Laubender
( Adobe Community Professional )

 

EDITED. Both titles were not exactly the same. Corrected that.

L
LaubenderCorrect answer
Brainiac
August 2, 2022

Hi @KuriousKatie ,

if the shapes were text frames that contain the words "safe" or "unsafe" you could do this with GREP Find/Change and apply a certain paragraph style that is formatted with Paragraph Shading with a huge offset that will be cut to the text frame's edges.

 

GREP Find pattern could be:

^safe\Z

Change to paragraph style "Safe" with that paragraph shading with color "Green".

 

GREP Find pattern could be:

^unsafe\Z

Change to paragraph style "Unsafe" with that paragraph shading with color "Green".

 

From my German InDesign 2022:

 

After the change some text selected where the new paragraph style is applied:

 

 

Note:

Unfortunately you cannot do this with a GREP Style, because an applied character styles's formatting like underline cannot be restricted to the shape of the text frame.

 

Download my test document from my Dropbox account and look into the paragraph styles:

https://www.dropbox.com/s/8a48qhs54vpvq3z/ConditionalFormattingShapes-GREP-FindChange-2022.indd?dl=1

 

Hm, but hold on, you said:

"The words will be within text paths inside of the shapes."

 

If the text path (or better a text frame) is pasted inside another shape you could apply a paragraph style with some GREP Styles and the applied underline stroke of the GREP Styles will be restricted by the path of the outer shape!

 

See page 2 of my test file where I pasted a text frame inside the shape that either contains the word "safe" or "unsafe".

The applied paragraph style has two GREP Styles that apply either character style "Safe" or character style "Unsafe" depending on the contents of the frame. Make sure that the text frame is as wide as the shape or wider; I have set the justification of the paragraph to Full Justified so that the applied underline is as wide as the text frame.

 

On page 2 we have a graphic frame that contains a text frame with the word "safe":

 

Below the text frame outside of the shape to show the formatting of its text:

 

The character style "Safe":

 

The GREP Styles of the applied paragraph style:

 

So I think, you'll find your solution on page 2 of my test document.

 

Regards,
Uwe Laubender
( Adobe Community Professional )

    K
    KuriousKatieAuthor
    Known Participant
    August 2, 2022

    Thank you for your help Uwe 🙂

    That is such a brilliant solution!

    I've added it to mine to see how we can incorporate it, however I have noticed that it doesn't seem to work when populating via a csv data merge. Only seems to work when manually inputting the words. Very strange, as the words are definitely there.

    brian_p_dts
    brian_p_dts
    Brainiac
    August 2, 2022

    I've put the test file onto my google drive for you to take a look at - if you don't mind 🙂

    In there is the test csv file I am using for the data merge also.

     

    https://drive.google.com/drive/folders/1G189TpdQ2Cd_US10Zmry4udyeCxiiwQl?usp=sharing


    It would not work in preview mode of DataMerge; only after you've executed the merge. 

    m1b
    m1b
    Brainiac
    August 2, 2022

    Just as a side note, it might be a sensible time to use Object Styles for "Safe" and "Unsafe", and the script would just apply either object style. That way, you can configure all attributes of the shapes' appearance very easily. - Mark

      K
      KuriousKatieAuthor
      Known Participant
      August 2, 2022

      That sounds like a good idea - would that need much more adding to the script to enable that?

      However, nothing else needs to be changed on the shapes, only the colour 🙂

      brian_p_dts
      brian_p_dts
      Brainiac
      August 2, 2022

      You didn't specify that you were dealing with text paths or cells, so this would do it for all text frames in the doc. Assumes the swatches are named "Green" and "Red" respectively. 

      var doc = app.activeDocument;
var green = doc.swatches.itemByName("Green");
var red = doc.swatches.itemByName("Red");
var apis = doc.allPageItems;
var i = apis.length;
var saferx = /safe/gi;
var unsaferx = /unsafe/gi;
while (i--) {
   if (apis[i] instanceof TextFrame) { 
        if (apis[i].contents) { 
             if (unsaferx.test(apis[i].contents)) { 
                  apis[i].fillColor = red;
             } else if (saferx.test(apis[i].contents)) { 
                  apis[i].fillColor = green;
             }
        }
   }
}
      K
      KuriousKatieAuthor
      Known Participant
      August 2, 2022

      Sorry, my apologies 🙂

      The words will be within text paths inside of the shapes.

       

      Just to be sure, I need to make sure there are defined colour swatches with "green" and "red" before I run this script? 🙂

       

      Just on my commute to work, will try this script when I get in 👍 fingers crossed!

      brian_p_dts
      brian_p_dts
      Brainiac
      August 2, 2022

      Capital Red and Green. Text paths spanning multiple shapes may require finessing. Let us know

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices