how to highlight result of logical function
 

I am using Excel 2003 and I am using a simple logical function

=If(I8=J8,"PASS",'"FAIL").

This works fine, however, I am trying
to figure out how to have the PASS highlighted in Lime Green and
FAIL Highlighted in red automatically.

Can anyone help?

Thank you,

Curtis

how to highlight result of logical function
 

Select the cell.
Click on Format, Conditional Formatting
Next to Cell value is , enter =PASS
Click on Fomrat
Click on Pattern
Select the colour you want (Lime green)
Click on Add
Next to Cell Value is, enter =FAIL
Click on Format
Click on Pattern
Click on the red square
OK out

--
HTH

Kassie

Replace xxx with hotmail


"clipski" wrote:

I am using Excel 2003 and I am using a simple logical function

=If(I8=J8,"PASS",'"FAIL").

This works fine, however, I am trying
to figure out how to have the PASS highlighted in Lime Green and
FAIL Highlighted in red automatically.

Can anyone help?

Thank you,

Curtis

how to highlight result of logical function
 

Must have been dreaming?
Click on Format, then Conditional Formatting
Block next to Cell value is, select Equal to
In the block next to that, enter PASS
click on Format
Clcik on Patterns
Select lime green
Click on Add
In the block next to Cell value is, select Equal to
In the block next to that, enter FAIL
Click on Format
Click on PPatterns
Select Red
OK out

--
HTH

Kassie

Replace xxx with hotmail


"clipski" wrote:

I am using Excel 2003 and I am using a simple logical function

=If(I8=J8,"PASS",'"FAIL").

This works fine, however, I am trying
to figure out how to have the PASS highlighted in Lime Green and
FAIL Highlighted in red automatically.

Can anyone help?

Thank you,

Curtis