See how to Conditionally Format each row in a Data Set that has a Job Title that contains any text item from within a list. Learn about “Contains Criteria” in an OR Logical Test:
(02:53) OR, ISNUMBER and SEARCH functions in an Logical Array Formula that requires Ctrl + Shift + Enter (in the cells). Learn how Array Formulas that require Ctrl + Shift + Enter will work in the Conditional Formatting Dialog Box.
(08:45) Convert Contains Criteria list to an Excel Table to allow the list of criteria to expand or contract.
(10:13) LOOKUP and SEARCH functions in an Logical Array Formula that does NOT requires Ctrl + Shift + Enter (in the cells). Learn how the Big Number 2^15 can be used in an Approximate Match Lookup Formula when searching for text in a cell.
Not in video, but in the downloadable Workbook compare and time the LOOKUP Formula using either SEARCH or MATCH functions.