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