Excel Magic Trick 1227

DESCRIPTION

Conditional Format: Min, Max & Min Value Greater Than Zero
Learn how to:
(00:12) Problem Introduction
(00:38) Conditionally Format the Maximum value in a set of numbers with built in Top 1 Rule
(01:32) Conditionally Format the Minimum value in a set of numbers with built in Bottom 1 Rule
(02:07) Conditionally Format the Min Value Greater Than Zero (First Value Bigger Than Zero). Array Formula using MIN and IF functions.

WORKBOOKS




Be the first to comment

Leave a Reply