Cell background shading in Excel

[Jerry]

Why is it that the background shading colors available
under the Paintbucket Icon chjange from file to file?
Also, how can I add some of the colors to the paintbucket
that are availabe under the format/cells/pattern pulldown?

 

[JE McGimpsey]

Colors are a Workbook-level property, so you can change the color
palette for any workbook. Choose Tools/Options/Colors... and modify the
colors to your hearts' content. You can also import another workbook's
color palette from that dialog.

Note however, that there are only 56 bins in the color palette, so you
can only use 56 colors at a time. The paint bucket displays the first 40
colors, so make sure that any background colors you want are in that
range.