View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
kassie kassie is offline
external usenet poster
 
Posts: 515
Default 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