Excel Magic Trick 1345

Conditionally Format Product Name for No Items Entered in Row (4 Methods)

DESCRIPTION

See how to use a Logical Formula and Conditional Formatting to highlight Product Name when no items are entered in the row. See 4 methods:
(00:11) Introduction to Using Logical Formulas to Apply Conditional Formatting.
(01:30) Method 1: COUNTA function with Equal Sign Comparative Operator. COUNTA function counts cells that are not empty.
(02:54) Method 2: COUNTA and NOT function. NOT function converts TRUE to FALSE and FALSE to TRUE.
(03:52) Method 3: COUNT function with Equal Sign Comparative Operator. COUNT function counts cells that contain numbers.
(04:37) Method 4: SUM function with Equal Sign Comparative Operator. SUM function adds numbers and will ignore Text Values.
(04:58) Conditional Formatting Dialog Box for Logical Formulas. “Use a formula to determine which cells to format”. “Format values where this formula is true”.
(06:18) Conclusion

WORKBOOKS

Download “Excel-Magic-Trick-1341-1360.zip” Excel-Magic-Trick-1341-1360.zip – Downloaded 6965 times – 23 MB







Be the first to comment

Leave a Reply