When formatting cells, is there a way of chosing from a wider colour range. The colour options I can see are quite flashy...

Hello Anne,

Hope you enjoyed your Microsoft Excel course with BEST Training.
Thank you for your question regarding Formatting cells

I remember saying yesterday that is could not be done, and I found a way to make it happen.

To modify the color palette for a workbook, follow these steps:

Microsoft Office Excel 2003 and earlier versions of Excel
1. Start Excel, and then open the workbook.
2. On the Tools menu, click Options, and then click the Color tab.
3. Click the color that you want to change, and then click Modify.
4. Use one or more of the following procedures: • To replace the selected color on the palette with a different standard color, click the Standard tab, and then click the color that you want.

• To change the hue or another aspect of the selected color, click the Custom tab, and then change the options.

5. Click OK.
6. Repeat steps 3 through 5 as needed, and then click OK.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer