When you pick a different Theme or Theme Color scheme, colors used in the sheet will change only if they are Theme Colors to begin with. If a color has been selected from the Standard Colors or one of the More Colors. Options it severs the relationship between the element & the Theme in effect at the time. If you apply shading to a cell by selecting one of the colors in the current Theme, that shading will change if a different Theme or Theme Color scheme is selected, but. If you apply the shading by picking a color that is not a part of the current Theme the fill color will not change if you pick a different Theme or Theme Color scheme. Two additional points:. You cannot map colors to other colors.
You can only specify what colors are used for specific purposes. In PPT go to the Themes tab of the Ribbon, click the Colors button in the Theme Options group & select Create Theme Colors. That dialog will also give you a clearer indication of what the colors apply to. Once you name & save the custom color scheme it will be available to the other Office apps. In Mac Office, custom Theme Color schemes can be created only in PowerPoint. They cannot be created or modified in Word or Excel. Please mark HELPFUL or ANSWERED as appropriate to keep list as clean as possible ☺ Regards, Bob J.