General

Re: Multiple conditionals within a common control

workin'stiff — Mon, 04 Jun 2012 20:20:07 GMT

I ended up splitting everything into six separate conditions. And it worked like a champ!

Sometimes it all about the KISS concept.

Thanks for the help!
Tom

Re: Multiple conditionals within a common control

Jimmy — Mon, 04 Jun 2012 19:20:57 GMT

I have a feeling that the issue here is the associativity of AND and OR. AND has a higher precedence than OR, so in this case, what you're actually getting is:

[TB1 is equal to 39,000 AND TB2 is less than 3500] OR TB2 is greater than 3700
[TB1 is equal to 40,000 AND TB2 is less than 3670] OR TB2 is greater than 3870
[TB1 is equal to 41,000 AND TB2 is less than 3840] OR TB2 is greater than 4040

I'd suggest either splitting this out into 6 conditions:

1. TB1 is equal to 39,000 AND TB2 is less than 3500
2. TB1 is equal to 39,000 AND TB2 is greater than 3700
etc.

or you can use 3 exceptions, but have the OR part entered on a single line, as a manually-entered condition:

1. TB1 is equal to 39,000 AND
(TB2 is less than 3500 OR TB2 is greater than 3700)
etc.

Multiple conditionals within a common control

workin'stiff — Mon, 04 Jun 2012 19:09:38 GMT

Hi everyone,

I've got an issue where I need to have multiple conditionals (read formatting) within a common control. See my example below.

Text Box 1 (Integer)
Text Box 2 (Integer)

Text Box 1 (e.g. TB1) will contain one of three user entered values - 39,000 / 40,000 / 41,000.

If the user enters 39,000 into TB1, the acceptable range for Text Box 2 (TB2) needs to fall within 3500 to 3700.
If the user enters 40,000 into TB1, the acceptable range for TB 2 is 3670 to 3870.
If the user enters 41,000 into TB1, the acceptable range for TB2 is 3840 to 4040.

I currently have the conditional formatting set up within TB 2 as follows (each of the items below are a separate conditional):

TB1 is equal to 39,000 AND TB2 is less than 3500 OR TB2 is greater than 3700
TB1 is equal to 40,000 AND TB2 is less than 3670 OR TB2 is greater than 3870
TB1 is equal to 41,000 AND TB2 is less than 3840 OR TB2 is greater than 4040

The problem is that only the first set of conditional formatting is being applied to TB2, regardless of the value within TB1. Am I misinterpreting the funcitonality of the AND within setup of the conditional formatting?

Let me know if I need to provide additional clarification.

Thanks in advance!
Tom