Where (menu) find "fill color" and define/add a new color?

  • Thread starter Thread starter Claudia d'Amato
  • Start date Start date
C

Claudia d'Amato

In my toolbar I found an icon "Fill color".

Where is the refering (sub) menu?
I did not found such a sub menu for the palette.

How do I add a new color to the existing palette?
I neither find an "add custom" or similar button
nor a way to change existing colors.

Claudia
 
I assume you are talking about Excel 97-2003

The Palette has 56 colours, you cannot add additional colours. Only 40
appear in the dropdown palette; the other two rows, known as the chart
colours, appear in various format dialogs.

To customize a colours manually
Tools / Options / Color

Programmatically -
ActiveWorkbook.Colors(3) = RGB(50, 150, 250)
changes default red to a blue


The palette "belongs" to the Workbook and that workbook only. If you
customize a colour the new palette will be saved with the workbook.

Note the 56 'Colorindex' numbers are not located in any kind of logical
order in the palette.

Regards,
Peter T
 
Back
Top