Hide section based on multiple conditions not working

B

Brad Christie

I have a section I wish to hide if any value but the 4 allowed values are
entered into a text box.

Example: If the user enters 1a, 2x, 12 or AB into the text box the section
will show, any other value and it's hidden.

I can get it to work with one condition set but not four. This is what I'm
doing:
On the section I set conditional format to - If field1 is not equal to "1a"
then hide, then with a second condition, If field1 is not equal to "2x" then
hide ...and so on.

What am I doing wrong?
 
S

Shiva (GGK Tech)

Hello,
Between four conditional formatting you should be use ‘and’ in last
dropdown. This dropdown will display when you are try to add one more
condition in existing conditional formatting. You might be added four
different conditional formatting right? This will be treated as ‘or’
conditional formatting which is not works for you.
 
K

Kalyan G Reddy MVP (GGK Tech)

Hello

Use the conditional formatting ion the section and Use the "and" between the
different conditions like

Field1 is not equal to "1a" and
Field1 is not equal to "2x" and
Field1 is not equal to "12" and
Field1 is not equal to "AB"
then
Hide the Control

Field 1 is your text box
 
B

Brad Christie

I was using the "or"
Thanks for that

Kalyan G Reddy MVP (GGK Tech) said:
Hello

Use the conditional formatting ion the section and Use the "and" between the
different conditions like

Field1 is not equal to "1a" and
Field1 is not equal to "2x" and
Field1 is not equal to "12" and
Field1 is not equal to "AB"
then
Hide the Control

Field 1 is your text box
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top