Change colors applied from theme to customized colors

[antaeusguy]

In Excel 2007/2010, when a color is applied to a cell interior from the theme colors, the cell color will change if the theme is changed.

For customized colors (applied from "More colors..." > choosing from standard colors (the hexagon shaped palette) or custom colors (by defining the RGB/HSL values)), the cell color will not change according to the changed theme.

If I applied colors from themes to my fonts/cell interior, how do I convert it to customized colors so that it will not change according to the themes?

 

[mikerickson]

You could set a custom color to the color of the cell

With Range("A1")
    .Parent.Parent.Colors(10) = .Interior.Color
    .Interior.ColorIndex = 10
End With

Of course that would change all colorindex 10 cells in the workbook