(08:00) Number Outside range with lower and upper hurdle. Numbers below the lower hurdle OR above the upper hurdle.
(01:25) OR function. OR Criteria: only one TRUE is necessary for OR function to deliver a TRUE.
(02:50) Evaluate Formula.
(03:17) IF function to put text “Outside Range”.
(05:00) Conditional Formatting for number values outside range using Built-in Conditional Formatting “Not Between”
(05:59) Conditional Formatting Text using Built-in Conditional Formatting “Cell Contains”
(06:44) Conditional Formatting whole row or whole record using OR function and Mixed Cell References.