1. Select the cell A2.
2. Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a
formula to determine which cells to format. Enter the formula in the box
below.

=C2="completed"

4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK


If this post helps click Yes
---------------
Jacob Skaria


"Joe" wrote:

Using MS office 2007.

How to conditional format cell A2 basing on the value of the cell C2.
The color fill is white if the value of the cell C2 is "ongoing" and red if
the value is "completed".