Conditions

You can create checks on your spreadsheet data based on a variety of conditions. The conditions you can use depends upon the type of data that you are checking.
Numbers
For cells containing numbers you can define checks to see if they are:
Valid Number
Not Valid Number
Empty
Not Empty
Equal To
Not Equal To
Greater Than
Greater Than Or Equal To
Less Than
Less Than Or Equal To
One Of (CSV list of values to compare against)
Not One Of (CSV list of values to compare against)
Matches Regex (JavaScript RegExp to test the value)
Between (inclusive range of values as a CSV, e.g. 1,5 means between 1 and 5)
Text
For cells containing text you can define checks to see if they are:
Empty
Not Empty
Equal To
Not Equal To
Starts With
Ends With
Contains
Does Not Contain
One Of (CSV list of values to compare against)
Not One Of (CSV list of values to compare against)
Matches Regex (JavaScript RegExp to test the value)
Dates
For cells containing dates you can define checks to see if they are:
Yesterday
Today
Tomorrow
Equal To
Not Equal To
Before
After
Last modified 2mo ago