Conditional Formulas

Shade cells between 2 dates	Conditional - Formatting
Shade cells between 2 numbers	Conditional - Formatting
Shade cells in a particular row	Conditional - Formatting
Shade cells in alternate rows	Conditional - Formatting
Shade cells that are blank	Conditional - Formatting
Shade cells that are dates	Conditional - Formatting
Shade cells that are dates and business days	Conditional - Formatting
Shade cells that are dates and greater than a value	Conditional - Formatting
Shade cells that are dates and less than a value	Conditional - Formatting
Shade cells that are dates and weekdays	Conditional - Formatting
Shade cells that are dates and weekends	Conditional - Formatting
Shade cells that are dates in the next n days	Conditional - Formatting
Shade cells that are errors	Conditional - Formatting
Shade cells that are not errors	Conditional - Formatting
Shade cells that are not numbers	Conditional - Formatting
Shade cells that are not text	Conditional - Formatting
Shade cells that are numbers	Conditional - Formatting
Shade cells that are numbers and even	Conditional - Formatting
Shade cells that are numbers and greater than a value	Conditional - Formatting
Shade cells that are numbers and less than a value	Conditional - Formatting
Shade cells that are numbers and negative	Conditional - Formatting
Shade cells that are numbers and odd	Conditional - Formatting
Shade cells that are numbers and positive	Conditional - Formatting
Shade cells that are text	Conditional - Formatting
Shade cells that are text and do not contain specific text	Conditional - Formatting
Shade cells with dates equal to a value	Conditional - Formatting
Shade cells with duplicate rows	Conditional - Formatting
Shade cells with duplicate values	Conditional - Formatting
Shade cells with formatting	Conditional - Formatting
Shade items in a list that appear in a sub list	Conditional - Formatting
Shade positive changes	Conditional - Formatting
Test if a cell begins with x y or z	Conditional - If
Test if a cell contains 1 text string	Conditional - If
Test if a cell contains 1 word	Conditional - If
Test if a cell contains 2 text strings	Conditional - If
Test if a cell contains 2 words	Conditional - If
Test if a cell equals 1 value	Conditional - If
Test if a cell equals this	Conditional - If
Test if a cell equals this and another cells equals that	Conditional - If
Test if a cell equals this or that	Conditional - If
Test if a cell equals x y or z	Conditional - If
Test if a cell is between 2 numbers	Number - Test
Test if a cell is blank	Conditional - If
Test if a cell is greater than 1 value	Conditional - If
Test if a cell is less than 1 value	Conditional - If
Test if a cell is not blank	Conditional - If
Test if not blank multiple cells	Conditional - If
Test if this and that	Conditional - If
Test if this or that	Conditional - If
Test if with wildcards	Conditional - If

Shade cells between 2 dates Conditional - Formatting
Shade cells between 2 numbers Conditional - Formatting
Shade cells in a particular row Conditional - Formatting
Shade cells in alternate rows Conditional - Formatting
Shade cells that are blank Conditional - Formatting
Shade cells that are dates Conditional - Formatting
Shade cells that are dates and business days Conditional - Formatting
Shade cells that are dates and greater than a value Conditional - Formatting
Shade cells that are dates and less than a value Conditional - Formatting
Shade cells that are dates and weekdays Conditional - Formatting
Shade cells that are dates and weekends Conditional - Formatting
Shade cells that are dates in the next n days Conditional - Formatting
Shade cells that are errors Conditional - Formatting
Shade cells that are not errors Conditional - Formatting
Shade cells that are not numbers Conditional - Formatting
Shade cells that are not text Conditional - Formatting
Shade cells that are numbers Conditional - Formatting
Shade cells that are numbers and even Conditional - Formatting
Shade cells that are numbers and greater than a value Conditional - Formatting
Shade cells that are numbers and less than a value Conditional - Formatting
Shade cells that are numbers and negative Conditional - Formatting
Shade cells that are numbers and odd Conditional - Formatting
Shade cells that are numbers and positive Conditional - Formatting
Shade cells that are text Conditional - Formatting
Shade cells that are text and do not contain specific text Conditional - Formatting
Shade cells with dates equal to a value Conditional - Formatting
Shade cells with duplicate rows Conditional - Formatting
Shade cells with duplicate values Conditional - Formatting
Shade cells with formatting Conditional - Formatting
Shade items in a list that appear in a sub list Conditional - Formatting
Shade positive changes Conditional - Formatting
Test if a cell begins with x y or z Conditional - If
Test if a cell contains 1 text string Conditional - If
Test if a cell contains 1 word Conditional - If
Test if a cell contains 2 text strings Conditional - If
Test if a cell contains 2 words Conditional - If
Test if a cell equals 1 value Conditional - If
Test if a cell equals this Conditional - If
Test if a cell equals this and another cells equals that Conditional - If
Test if a cell equals this or that Conditional - If
Test if a cell equals x y or z Conditional - If
Test if a cell is between 2 numbers Number - Test
Test if a cell is blank Conditional - If
Test if a cell is greater than 1 value Conditional - If
Test if a cell is less than 1 value Conditional - If
Test if a cell is not blank Conditional - If
Test if not blank multiple cells Conditional - If
Test if this and that Conditional - If
Test if this or that Conditional - If
Test if with wildcards Conditional - If

Test if a cell contains 1 text string

You can check if a cell contains a particular text string by combining the ISNUMBER and SEARCH functions.

* Columns=1
* Width=800
* True
* True
* True
* False