Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

formatting cells

ResolvedVersion 2003

Anne has attended:
Excel Intermediate course
Project Intermediate course

Formatting cells

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

RE: Formatting cells

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:

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

New to Excel 2010 - Sparklines!

Excel 2010 includes a new feature called Sparklines which are tiny charts that fit into a single cell and plot data in cells from the worksheet. There are a host of formatting and styles that can be applied to them and they are really quite interesting.

>insert
>sparklines
>Choose any style you want

You will be asked for the range and it will automatically select the cell your in to insert the sparklines.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.