Conditional formatting

[Einat Reivh]

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?

 

[S.Y.M. Wong-A-Ton]

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