What if excel 2003

In this example, you need to apply formatting to the values in columns B-D but not column A, as there is no previous month's data to compare the values in column A to. Before entering the ' Con d itional Formatting In the above example spreadsheet on the right , cell B2 is the active cell, although cells, B3-B6 and C2-D6 have also been selected.

It is important to be aware of the active cell when using references to define Excel Conditional Formatting - as explained below. Select the Con d itional Formatting This will cause the 'Conditional Formatting' dialog box to open.

Within this dialog box:. Using the mouse to click on the symbol, then click on the cell A2. These selections are shown in the 'Conditional Formatting' dialog box below:. The resulting spreadsheet is shown above on the right.

As required, all cells containing values that are greater than the corresponding previous monthly values have been highlighted by formatting the text in bold and colouring it red. You can control the cell font, fill colour and border setting, based on the selected cell's contents, or based on the contents of another cell. If the rules conditions that you specified are met, then the formatting is applied.

For example, you can set conditional formatting so that a cell turns blue or green, based on its value. Note: To apply more than 3 conditional formas in a cell in Excel and earlier versions, you would need to use programming.

To view the steps for adding condtional formatting, watch this short Excel video tutorial. There are written instructions below the video.

Your browser can't show this frame. Here is a link to the page. If you do find yourself using multiple levels of nesting, you should probably consider whether there are other Excel functions that could be used to obtain the same result more succinctly.

For example, the above function could be made much simpler by using the Excel Choose function. Excel Functions. In each case: If the value in column B is equal to 0, a further call to 'If' is made, to test the value in column C. The average of the numbers is added to cell B7, or the cell immediately beneath the defined range of numbers.

Accessing Excel functions To access other functions in Excel: Using the point-click-drag method, select a cell range to be included in the formula. If you don't see the function you want to use Sum, Average, Count, Max, Min , display additional functions by selecting More Functions. The Insert Function dialog box opens. There are three ways to locate a function in the Insert Function dialog box: You can type a question in the Search for a function box and click GO.

Select the function you want to use, then click the OK button. Open your Monthly Budget file. Delete the number in C Type a function in cell C15 that adds the range of cells: C2 through C Fill the formula from C15 to D15 through O Type your Income for the month of February in D Type a formula in O17 that adds your savings for the year.

Because you have only entered data for the month of January and February, this amount indicates your savings for the two months. Save and close the Monthly Budget spreadsheet.