Text length between

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

Type: Display

Example:

• Cell value: Description

• Rule values:

  • Min length: 1

  • Max length: 11

• Result:

Observations:

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

• No orange border, indicating valid data.

Example:

• Cell value: D

• Rule values:

  • Min length: 1

  • Max length: 11

• Result:

Observations:

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

• No orange border, indicating valid data.

Example:

• 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.