how do you highlight the result of an IF statement

[clipski]

Hello,

I have a simple If statement that results "PASS" if the statement is
true and "FAIL" if the statement is false. Is there a way that the
result can be automatically highlighted as well. I want "PASS" to be
in Lime green and "FAIL" to be in RED.

Thank you,

 

[Mike H]

Hi,

Apply a conditional format to these formula cells

Select on of them and then

Format|Conditional format
Select 'cell value is'
select 'Equal to'
enter Pass in the box and pick your colour

Click ADD and repeat the process for Fail.

Mike

 

[Per Jessen]

Hi

Select the PASS/FAIL cells and goto Format > Conditional formatting >
Condition 1: Formula is > Enter this formula in the next field :
=A1="PASS"

Format as desired. Click Add to enable Condition 2, and repeat as abowe.
(Change A1 to reference first Pass/Fail cell)

Hopes this helps.
....
Per

 

[Justin Case]

Hello,

I have a simple If statement that results "PASS" if the statement is
true and "FAIL" if the statement is false. Is there a way that the
result can be automatically highlighted as well. I want "PASS" to be
in Lime green and "FAIL" to be in RED.

Thank you,

Use Conditional Formatting from the format menu. Select "equal to" as
the "Cell value is" condition, type in "PASS" Choose the Format
buttom, select green, press OK. Press the ADD>> button to get another
condition box and do the same for FAIL, with a red color.

If your formula may result in a result of other than pass/fail you can
choose a third condition. This time change "cell value is" to "formula
is" The formula, depending on your cell location would be..

=AND(A1<>"PASS",A1<>"FAIL")

Select another color for this condition, press OK.

Regards,
Justin

 

[Bernard Liengme]

If you need more help, Debbie tells how to use CF
http://www.contextures.com/xlCondFormat01.html
best wishes

 

[Shane Devenshire]

Hi,

In 2007 choose Home, Conditional Formatting, Highlight Cell Rules, Equal to
and type PASS. Change the format as needed from the items on the right.

Repeat the steps above and enter FAIL ...