Text is in list

.

Type: Display

Description: Entries are separated by a pipe symbol '|'. If the cell value matches an entry, the rule succeeds.

Example: Fail

• Cell value: Desc

• Rule value:

abc|def|ghi

• Result: Rule Fails - Cell value "Desc" does not match any list value

Example: Success

• Cell value: Stainless Steel

• Rule value:

Stainless Steel|Bronze|Metal

• Result: Rule Succeeds - Cell value "Desc" does not match any list value