Text length between

Type: Display

Description: The number of characters in the cell value must be between the lower and upper limit (both inclusive).

Example: Success

• Cell value: Description

• Rule values:

  • Min length: 1

  • Max length: 11

• Result: Rule passes because the length of 'Description' is 11

Observations:

• 'Description' is 11 characters long and falls within the ranges.

• No orange border, indicating valid data.

Example: Success

• Cell value: D

• Rule values:

  • Min length: 1

  • Max length: 11

• Result: Rule passes because the length of 'D' is 1

Observations:

• 'D' is 1 character long and falls within the ranges.

• No orange border, indicating valid data.

Example: Fail

• Cell value: Descriptions

• Rule values:

  • Min length: 1

  • Max length: 11

• Result:

Observations:

• 'Descriptions' is 12 characters long and falls outside the ranges.

• Orange border, indicating invalid data.