Excel Magic Trick 1307

Conditionally Format Multiple Non-Adjacent Cells in Cross Tabulated

DESCRIPTION

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

WORKBOOKS

Download “Excel Magic Trick 1301-1320” Excel-Magic-Trick-1301-1320.zip – Downloaded 344 times – 285 KB




Be the first to comment

Leave a Reply