A new feature in Excel 97, conditional formatting lets you flag key cells in your worksheet depending on what they contain. For example, you can tell Excel to change the background color of a cell whenever the number in it meets or exceeds a certain value. Here’s how to do it:
Select the cell(s) you want to format.
Select Conditional Formatting from the Format menu.
Under Condition 1, go to the second box from the left and select a condition (greater than, less than, whatever).
In the third and, if necessary, fourth boxes from the left, enter values.
In the Format Cells dialog box, set up the format you want Excel to apply when your condition is met. You can change the settings for the font, cell borders, and background color. When you’re done, click OK.
In the Conditional Formatting dialog box, click OK.