Conditions Supported by the Rule Builder
These conditions are supported by the data validation rule builder: If, Else, Else If, Then, Check Range, and Range.
For details and examples of the values supported by these conditions, see these sections:
-
If, Else, Else If: If Condition Values
-
Then: Then Condition Values
-
Check Range, Range: Range Condition Values