Conditional Formatting confusion

J

Jono

I need to set a text box's conditional formatting so that it is displayed when
either one of two conditions in a group are selected. Let's say I have 10
checkbox choices. Two of these choices require a textbox for further info. I
want the textbox to be hidden when neither of the two are checked. A logical
OR gate.

In the conditional formatting I only have the choice to 'hide' the control
under certain circumstances, this causes a problem: If I say hide this
control
if one of the other 8 are checked and I need to check one of them and one of
the check boxes that need the text box the text box won't show up because of
the negative conditional formatting.

What I need is 'Show this control' if one of the two check boxes are checked.

Any ideas?
 
S

S.Y.M. Wong-A-Ton

'Show this control' if one of the two check boxes are checked is the same as
'Hide this control' when one of the two check boxes are not checked. So set
conditional formatting on the textbox to 'Hide this control' with two
conditions that say:
1. checkbox 1 is equal to FALSE
OR
2. checkbox 2 is equal to FALSE
 

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