There are several limitations of the current edit colors dialog:
- Only 20 colors are available for manual assignment in the edit colors dialog--even if more exist. Current workarounds are to use the Assign Palette button (does not work for manual assignment), or split the palette into multiple batches of 20 (time consuming and arduous)
- The only way to create a custom color palette is to edit the XML in the Preferences.tps file
- Custom color palettes do not travel with .twbx files.
- There is no way to create a theme for a workbook.
Suggestion, create a system of color editing and management similar to any Adobe product.