Excel Magic Trick 1087

OR & IF Function & Conditional Format: Number Outside Lower & Upper Hurdle


(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.


Download “Excel Magic Trick 1082 - 1100” Excel-Magic-Trick-1082-1100.zip – Downloaded 452 times – 2 MB

Be the first to comment

Leave a Reply