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
|