Create Logical Formula to conditionally format only certain cell sin cross tabulated report using a Boolean Array Operation inside the SUM function:
(00:13) Problem Set Up
(01:25) Look at Logical Formula using AND and OR functions and individual cells.
(02:02) Look at Logical Formula using individual cells in Boolean Formula
(02:33) Create Boolean Array Operation inside the SUM function and paste it into Conditional Formatting Dialog Box
(04:23) Learn about F9 key and Ctrl + Z and Esc key when formula is in Edit Mode.
(07:00) Paste Array Formula into Conditional Formatting Dialog Box