1-866-245-5224 sales@keystonelearning.com

Excel 2003: Set Conditional Formatting

Excel 2003: Set Conditional Formatting

Another way to ensure the proper data is being entered into a cell is through Conditional Formatting. With Conditional Formatting, you can set parameters on individual cells. When those parameters are met, Excel will automatically change the formatting of the affected cells for you.

For example, in the event you wanted only whole numbers between 1 and 100, if a cell was updated to display 150, you can have Excel flag that cell by changing the data within to red. This way, the invalid entry would still be allowed in your worksheet, but it would trigger a reminder to you that it needs to be checked.

Conditional Formatting is also great when watching budget numbers or stock prices. If the numbers fall below a set range, Excel can format them one way; yet, if they rise above a set range, Excel can format them another way.

Adding Conditional Formatting

     
  1. Select the cells to which you want to apply the conditional formatting
     
  2.  
  3. Choose Format: Conditional Formatting… from the Menu bar
     

Figure 19. Conditional Formatting Dialog Box

   3.      Set your Value and your Format

   4.      Click OK

You can continue adding conditional formats to the same range of cells. To add a second or third conditional format to the same cell(s), click the Add button before you click OK to close this dialog box.

Changing Conditional Formatting

     
  1. Select the cells to which you want to apply the conditional formatting
     
  2.  
  3. Choose Format: Conditional Formatting… from the Menu bar
     
  4.  
  5. Click Delete
     

Figure 20. Delete Conditional Format Dialog Box

   4.      Select which conditional formats you want to remove from the highlighted cells

   5.      Click OK

   6.      Click OK