I have a macro that will take data in an excel workbook and build tables with that data in PowerPoint. The last issue I have is that of color. I would like to color code my tables. Now I have the proper coding to make it happen, but I am runnnig into a compatability issue.

I am assigning the colors by use of the table style id. I like how the preset table styles look so I dont need to do anything fancy. The problem is the table style ids that are in Excel do not match that of any that are in PowerPoint.

If I use this style id In Powerpoint it is an orage theme, but when I put that style into Excel it builds the table style as red.

i need a style Id that is green and orange.