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

excel

ResolvedVersion 2007

Bhavna has attended:
Outlook Introduction course
Upgrade to Office 2007 course

Excel

On a budget spreadsheet you have budget actual and variance. How do you change the variance number if the number is a minus and shaded in Black?

RE: Excel

Hi Bhavna, thanks for your query. If I recall correctly, your query is to do with the colour formatting of positive and negative currencies and you're experiencing some mismatch on your budget and variance sheets. I think this has to do with your currency formatting. Select the cells on the worksheet with the figures in it, then right-click and choose Format Cells. You need to make sure that the Currency format is correctly applied to those cells in the appropriate worksheet. For example, if the values are negative you can choose the red and negative format, and vice versa.

I hope this helps. Let me know if you need any more help with this.

Anthony

Wed 7 Jul 2010: Automatically marked as resolved.

 

Training courses

Training information:

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.

Microsoft Office tip:

Draw a perfect square or circle

Click on the Rectangle or Oval button on the Drawing toolbar. (If necessary, click Customize on the Tools menu, and then click the Drawing check box on the Toolbars to display the toolbar.)
Press and hold down both the [SHIFT] key and the mouse button.
Drag the mouse pointer diagonally downward and to the right until the rectangle or circle drawn has your preferred measurements.
Release the mouse button.
Release the [SHIFT] key.
In short, simply hold down the SHIFT key while dragging the mouse pointer!

View all Microsoft Office 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.