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”.