Allows you to set the 56 colours available to the workbooks. There are 40 standard colours and 16 for charts (8 for fills, 8 for lines). The 'chart' colours can also be used for anything which can have a colour 'fill, line, etc.

You are also able in charts to use any of the 56 colours, it is set here for the first 8 that excel will use 'automatically'.

Clicking on the 'Modify...' button, will show the dialog below, which has to tabs with 'coarse' colour selection (1), or fine tuned colour selection, (2). Selecting any square on the first dialog, (above) and then selecting a colour on either of these two tabs, will replace the colour selected in the palette.

1. (Standard Tab)

2.(Custom Tab)

This second tab has the ability to set the RGB (Red, Green, Blue) and HSL (Hue, Saturation, Luminescence), to arrive at very precise colours.

Setting 56 colours this way each time can be laborious, so if you set a workbook once with certain colours. (This may be a template with 'in-house' colours for example), you can open this each time and then, in another workbook, import the colour palette, by using the 'copy colors from' drop-down on the main tab. (As below).