5 Replies Latest reply on Mar 4, 2014 1:53 PM by Obi-wan Kenobi

    Change color of an object based on a score

    jamesallgood

      I am merging data into a document and have everything working well with one exception. I have a circle with a number (0-100) inside it. I want to be able to change the color of the circle based on the number. Low numbers should be in a red circle, middle numbers in a yellow circle, high numbers in a green circle. Do I need to use a script for this or can I include the CMYK values in my CSV? If I create a script, what variable do I assign CMYK values to in order to get the color of the circle to change?

       

      I could just create 3 different templates and break up the CSV into three different files but I would love to figure this out for my own sake.