Excel Tip: Find and Conditionally Format Greatest Range Difference

This is a template that I used today in working through a statistics problem. In the video we will cover

-finding the greatest and smallest values in a range with MAX and MIN
-a simple IF statement
-conditional formatting across a selection of cells (advanced! few analysts know how to do this).