How to format a cell based on the value of another cell (conditional formatting)

  1. Select the cells for which you want to add conditional formatting.
  2. On the Format menu, click Conditional Formatting.
  3. The Conditional Formatting dialogue will open.
  4. xcformatf2.gif

  5. In the first combo box select Formula is.
  6. In the text box next to it write the formula as follows: =$A$1<100. An equal sign followed by the cell reference followed by a comparison or a condition.
  7. Click the format button, the Format Cells dialogue will open.
  8. xcformat.gif

  9. Select the formatting you want to apply when the cell value meets the condition e.g. you can set the font color to red.

In this example, if the value of cell A1 is less than 100, then the color of the selected cells will be red.

Applies to: Excel 2003