AnsweredAssumed Answered

Conditional Formatting

Question asked by ShawnFitzgerald on Oct 13, 2013
Latest reply on Oct 13, 2013 by Markus Schneider


Conditional Formatting


     I am trying to do conditional formatting but I have two values that need to be the condition and for whatever reason I cannot figure out the formula for an empty Field I know this is simple and yet it eludes me.  For instance I have the current formula of

     ServiceTickets::INVOICE# = "False" & ServiceTickets::STATUS = "Complete"

     I know the "False" is Wrong. What do I put there so that if Field ServiceTickets::INVOICE# is empty and ServiceTickets::STATUS = "Complete" Then I want the condition I set to occur?

     I get stuck on the easy things thank you so much for being here I do not know what I would do without this resource.