Excel Conditional Formatting

Conditional Formatting – New in Excel 97

Conditional Formatting can be used to easily track changes or trends in data. You can specify up to three conditions and specify a different format for each condition. For example, you can specify one format to be applied when a data item increases by a certain percentage and another format if it decreases by a certain percentage.

Here's how to do it:

1. In a worksheet containing one or more cells of numeric information, select the cell range (or an individual cell) to which you want to apply conditional formatting.
    
2. Select Conditional Formatting from the Format menu.
    
3. Under Conditiona1, select either Cell Value Is or Formula Is. From the second field, select an operator: less than, greater than, between, etc. Enter a value in the third field.
    
4. Click on Format… to specify the format to use when the condition is met.
    
5. To add a second condition, click on Add >> and repeat steps 3 and 4.
    
6. Repeat for a third condition.
    
7. Click on OK to close the window and view the results of your conditional formatting.