Excel Digest

To format a cell based on the value of another cell follow these steps:
1. Select the cell you want to format, “A1″ in this example.
2. In the Home tab, Styles group, click on Conditional Formatting.
3. Select New Rule.

4. The New Formatting Rule window will open.

5. Click Use a formula to determine which cells to format.
6. The New Formatting Rule [...]

Select the cells for which you want to add conditional formatting.
On the Format menu, click Conditional Formatting.
The Conditional Formatting dialogue will open.

In the first combo box select Formula is.
In the text box next to it [...]