Conditional formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Einat Reivh - 04 Jan 2006 09:52 GMT

I need to insert about 10 or more conditions on a section. but I need the
delimiter between them to be "and". the problem is that I can only insert 5
conditions with "AND" delimiter. if i add another condition (using th "add"
botton) i can creat another consition containing 5 sub-conditions with a
logical AND between them. but the two "big" conditions have a logical "OR"
between them. what are my options here?

Reply to this Message

S.Y.M. Wong-A-Ton - 04 Jan 2006 14:44 GMT

Hi,

You can create one "big" condition containing one sub-condition and in this
sub-condition use "Use a formula..." in the third dropdown list box to
concatenate your many sub-conditions yourself by typing "and" (without the
quotes) between the sub-conditions. The same can be achieved by using "The
expression" from the first dropdown listbox and then typing in your
sub-conditions joined by an "and" (without the quotes).

Hope this helps.

Regards,
S.Y.M. Wong-A-Ton

> I need to insert about 10 or more conditions on a section. but I need the
> delimiter between them to be "and". the problem is that I can only insert 5
> conditions with "AND" delimiter. if i add another condition (using th "add"
> botton) i can creat another consition containing 5 sub-conditions with a
> logical AND between them. but the two "big" conditions have a logical "OR"
> between them. what are my options here?

Reply to this Message