Cell Shading

[blatham]

Does anyone know if it is possible to get apply a broader range o
colours to a cells shading?

You seem to be limited to 40 standard colours from the patterns tab o
the format cells dialog but you have a lot more flexibility fo
colouring a drawing object for example

 

[Dave Peterson]

You can use 56 colors in a workbook.

You can see the current color scheme via: tools|Options|color tab

You can change any of the 56 to something else by clicking modify.

And you can see all 56 colors if you go through the format|cells|pattern tab.

You can read lots more about how excel works with colors at David McRitchie's
site:
http://www.mvps.org/dmcritchie/excel/colors.htm