If Statement Questions

[phorst]

Hello,
First timer.
I am using Excel 2003, on XP SP2.
Here is my formula. =IF(F2<=B2,"GOOD","BAD")

Is there a way to change the color of my result, specifically I want "GOOD" to display in green and "BAD" to display in red.

Any help would be appreciated.

 

[arthurbr]

Welcome to the board
You will need to use Conditional formatting
See the Format menu in XL.
If bad and good are the only possibilities, you will only have to introduce one condition, the other being the default color

HTH

 

[u742884]

Have you tried Conditional Formatting? Select one of the cells with your formula. From the Format menu, choose Conditional Formatting.

In Condition1, leave it as "Cell Value Is"; in the next field, change it to "equal to"; and in the last one key "Good". Then click the Format button and change the Pattern to green (you may want to make your font bold or white or both).

Click the the Add button to create Condition2. Repeat the process but with the word "Bad" and Pattern red.

Click OK. If nothing happens, go back into Conditional Formatting. For some odd reason, Excel likes to put extra quotes around your text values (I have no idea why it does this). If it shows """Good""", remove the extra quotes and click OK again--should be fine now.

Then just copy/paste this down through all of your IF formulas.

 

[phorst]

I tried highlighting the text in the formula, and then tried to change the text color, but it is greyed out. Is this what you mean?

 

[phorst]

Tried it and it worked.
Thanks for your help.