Conditional Formttg : using the Formula drop down.

[Zac]

I'm pretty good at using Cond Formtg for "values", but not too good when using the Formula drop down.
What formula can I use to do the following:
In C5 I will have a 0 or Higher.
In G5 I want the following result:
- If C5 = 0
- Then make the place a 0 in Bold/Red
- If >0 Make the Font Bold Black/Light Blue Cell.

My problem is how I tie C5 into the picture as simply as possible.

Thanks,
Mike
This message was edited by Zac on 2002-02-27 13:23

 

[Zac]

Figured it out.
I put an IF statement in G5, that places a zero here if C5 = 0. Then used Conditional Fornmtg from there to change colors based on the values in G5.

 

[Aladin Akyurek]

Activate G5.
Activate Format|Conditional Formatting.
Choose "Formula Is" and enter in the formula box:

=$C$5=0

Activate "Format".
Select the desired formatting on the Font tab appropriate for the 0 condition.
Click OK.
Activate Add.
Choose "Formula Is" for Condition 2 and enter in the formula box:

=$C$5>0

Activate "Format" and the appropriate formatting.