Text is not in list

The cell value must not match a value in a string list.

Type: Display

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

Example
  • Cell value: Desc

  • Rule value: abc|def|ghi

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

Last updated