hey, in excel 2000 i have set a condition in a cell as follows: IF((A44+C44)<C47,"Pass","Fail") and i would like to know how to turn the cell green if the result is "pass" and red if the result is "fail"

Use Conditional Formatting with the following conditions: Assuming the cell with the IF statement is A1:

Format...Conditional Formatting

Condition 1

Formula is - =IF(A1="Pass",TRUE,FALSE)

Format...Pattern...GreenCondition 2

Formula is - =IF(A1="Fail",TRUE,FALSE)

Format...Pattern...Red

Another way of doing the same thing is with the AND function

This function tests two or more conditions to see if they are all true.

And there can be up to 30 possible tests.The steps are the same as DerbyDad03 showed but the formula is different.

1st – Select the cell in which your formula is located

On the Menu Bar:

2nd - Format

3rd - Conditional Formatting

4th – Change “Cell Value is” to “Formula Is”

5th – Enter the formula:=AND((A44+C44)<C47)

Sub Menu Format :

6th - Patterns

7th - Choose Green

8th - Press OK9th Select ADD

10th – Change “Cell Value is” to “Formula Is”

11th – Enter the formula:=AND((A44+C44)>C47)

Sub Menu Format :

12th - Patterns

13th - Choose Red

14th - Press OK

15th - Press OKThere is only one test going on here, but with a little imagination, you could do more.

MIKE

You may have to change your formula.

As it is you are checking for

Greater Than and Less Than,

but what happens if it is an exact match?MIKE

That should be -My- formulas, not yours. MIKE

Ask Your Question

Weekly Poll

Do you believe Comcast and Time Warner should be allowed to merge?

Discuss in The Lounge

Poll History