Excel Magic Trick 1201


Conditional Format Product With No Sales (5 Examples)

DESCRIPTION

See how to:
(00:08) Problem Setup
(00:43) Format Product with NO Sales: COUNT & =0
(02:46) Format Product with NO Sales: COUNT & NOT (Any non-zero number = TRUE, Zero = FALSE)
(04:13) Format Product with NO Sales: COUNTA
(05:13) Format Product with NO Sales: AND & ISBLANK Array Formula
(08:31) Format Product with Sales: COUNT
Use formula to determine which cells to format
Format Values where this formula is TRUE

WORKBOOKS