conditonal format A2 using value in another cell C2

[Joe]

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".

 

[Jacob Skaria]

1. Select the cell A2.
2. Goto Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a
formula to determine which cells to format. Enter the formula in the box
below.

=C2="completed"

4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK


If this post helps click Yes