Conditional Formatting using multiple criteria
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!