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