Number between

Type: Display

Description: The number in the cell value must be between (inclusive) the numbers specified.

Example

• Cell value: 0

• Rule values:

  • Min val: 1

  • Max val: 5

• Result: Rule fails, since value is less than min value.

Example

• Cell value: 1

• Rule values:

  • Min val: 1

  • Max val: 5

• Result: Rule passes, since value is between min and max value (inclusive)

Example

• Cell value: 5

• Rule values:

  • Min val: 1

  • Max val: 5

• Result: Rule passes, since value is between min and max value (inclusive)