How Do You Use Conditional Formatting In Microsoft Excel 2007?
Microsoft Excel 2007 has a number of new and impressive features, one of which is enhancement to the conditional formatting function. There are many graphic interfaces as well as text formatting and cell formatting options available. Some of the easiest functions are clearly listed in the Conditional Formatting bar under the Home tab. Highlight the cells you wish to format. Then select the option you wish to use. We will take a look at the first two options in the next few steps. (Option 1) Select the Conditional Formatting Tab. Then select the rule. The first two options will allow you to highlight cells based on certain criteria. For this example, we selected Top/Bottom rules and chose to highlight cells which are above the average for the selected criteria (Which is cells containing a # which is 5 or greater.) (Option 2) Select the Conditional Formatting Tab. Then select the rule. The second set of options allows you to attach a graphic based on the cell criteria. For this example,
