tcasteel
05-24-2016, 10:21 AM
I currently am able to take data from an excel sheet and paste it into a new slide row by row in PowerPoint. (copy slide 1, then find and replace using the column headings vs text in the shapes and set to a loop till end of row count). What I have not been able to find is how to set the color of the objects in PPT based on the data contained in the cell. Such as the text displays "good" I want that object to be green. I am also trying to add a piece of clip art (star) if a text field contains "yes" text. Any ideas are appreciated.