# 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](https://en.wikipedia.org/wiki/Comma-separated_values) list of values to compare against)
* Not One Of ([CSV](https://en.wikipedia.org/wiki/Comma-separated_values) list of values to compare against)
* Matches Regex ([JavaScript RegExp](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide/Regular_Expressions) to test the value)
* Between (inclusive range of values as a [CSV](https://en.wikipedia.org/wiki/Comma-separated_values), 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](https://en.wikipedia.org/wiki/Comma-separated_values) list of values to compare against)
* Not One Of ([CSV](https://en.wikipedia.org/wiki/Comma-separated_values) list of values to compare against)
* Matches Regex ([JavaScript RegExp](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide/Regular_Expressions) 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