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.

	A
1	=ISNUMBER(SEARCH("tt", "better")) = -1
2	=ISNUMBER(SEARCH("t?e", "better")) = -1
3	=ISNUMBER(SEARCH("TT", "better")) = -1
4	=ISNUMBER(FIND("TT", "better")) = 0

The SEARCH function is not case sensitive.
You can replace the SEARCH function with the FIND function if you want a case sensitive search.
1 - Does the substring "tt" exist in the string "better".
2 - Does the substring with wildcard characters "t?e" exist in the string "better".
3 - Does the substring "TT" exist in the string "better".
4 - Does the substring "TT" exist in the string "better".
FIND
ISNUMBER
ISTEXT
SEARCH
User Defined - CONTAINS

Test if a cell contains 2 text strings

You can check if a cell contains two particular text strings by combining the SUM function with the ISNUMBER and SEARCH functions.

	A
1	=SUM(--ISNUMBER(SEARCH({"be", "so"}, "bettersolutions")))>0 = -1
2	=SUMPRODUCT(--ISNUMBER(SEARCH({"be", "so"}, "bettersolutions")))>0 = -1

The SEARCH function is not case sensitive.
You can replace the SEARCH function with the FIND function if you want a case sensitive search.
The array could be replaced with a named range.
The double unary operator (--) is used to transform True and False values into there corresponding 1 and 0 equivalents.
1 - Do the substrings "be" and "so" exist in the string "bettersolutions".
2 - Before Excel 2021 arrays could not be handled natively.
FIND
ISNUMBER
SEARCH
SUM
SUMPRODUCT
User Defined - CONTAINS

Test if a cell contains 2 words

	A
1	count(xmatch({"ab", "bb"}, textsplit("aa ab bb ba cc",{".",","," "},,1)))>=2

COUNT
TEXTSPLIT
XMATCH

Test if a cell is between 2 numbers

	A
1	IF(A1>0,IF(A1<10,"Yes","No"),"No")
2	IF(AND(A1>10,A1<10),"Yes","No")