IF Function Format Tutorial Part 1
Related Tutorial: Excel 2010 Format Tutorial
Although this tutorial makes use of a worksheet from a previous tutorial, it is not necessary to complete the IF function tutorial first. The format options covered in this tutorial can be applied to any Excel 2007 worksheet.
Instructions for downloading the IF function worksheet are covered in Step 2 of this tutorial.
Following the steps in the tutorial topics below walks you through applying a number of Excel's format options to the tutorial data. At the end of part two of this tutorial, your worksheet should match the image above.
Part 2 of this tutorial covers such topics as number formatting, shading alternate rows of data with conditional formatting, and using the fill handle and formatting.