8 Replies Latest reply on Jul 20, 2012 1:51 PM by RachelJacobsen

    Conditional Formatting using multiple criteria



      Conditional Formatting using multiple criteria


      Hi all!

      I need help with the syntex to use multiple criteria for conditional formatting. Here's the issue: I have two fields in the table. If either of these fields have data, I want a button to appear. I have created the button and here's the condition I have used: If not IsEmpty textfield1 then apply the formatting (which makes the button white - background color - it 'disappears). This works but if I add another condition like if textfield2 not is null do the same thing it wants both fields to be true to work - I want it to work if either field is true. Help! Thanks!