how do you highlight the result of an IF statement

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,

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

"clipski" wrote:

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,

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

"clipski" skrev i meddelelsen
...
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,

If you need more help, Debbie tells how to use CF
http://www.contextures.com/xlCondFormat01.html
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"clipski" wrote in message
...
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,

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 ...

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"clipski" wrote:

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,