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

blatham wrote:

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

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

--
blatham
------------------------------------------------------------------------
blatham's Profile: http://www.excelforum.com/member.php...o&userid=19441
View this thread: http://www.excelforum.com/showthread...hreadid=501460

--

Dave Peterson