Conditional Formttg : using the Formula drop down.

Zac · Feb 27th, 2002, 02:22 PM

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 · Feb 27th, 2002, 02:31 PM

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 · Feb 27th, 2002, 02:34 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 27th, 2002, 02:22 PM	#1
Zac Board Regular Join Date: Feb 2002 Location: Mike Posts: 796	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 ]

Feb 27th, 2002, 02:31 PM	#2
Zac Board Regular Join Date: Feb 2002 Location: Mike Posts: 796	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.

Feb 27th, 2002, 02:34 PM	#3
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	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.