Conditional Formatting (CF) is one of the most powerful tools in Excel for visualizing data. Because CF can use formulas as input to the CF process, the ability to create formulas based on different data visualization requirements is important. In this demonstration, the goal is to highlight values in a numeric range that are […]

via Using Conditional Formatting in #Excel to Highlight the N Closest Values to the Mean of a Range by David Hager — Excel For You