### Excel Magic Trick 1124

DESCRIPTION See how to Conditional Format Weekends & Holidays using the NETWORKDAYS.INTL & NOT functions. Conditionally format serial dates for weekends and holidays. Conditional Formatting. Format Conditionally. Logical Formulas. Format holidays and weekends. WORKBOOKS

### Excel Magic Trick 1119

DESCRIPTION See how to: 1. Create formula for Conditionally Formatting a Date when 44 days have passed 2. Create formula to Conditionally Formatting the whole row when 44 days have elapsed after a given date. [Read More >>>]

### Excel Magic Trick 1106

DESCRIPTION See how to add 3-D gradient conditional formatting to a row in a data set using the AND function to match student name and academic quarter. WORKBOOKS

### Highline Excel 2013 Class Video 48

DESCRIPTION Topics in this video: 1. Conditional Formatting: Bar Chart with Data Labels 2. Formula to Define length of Bar WORKBOOKS

### Highline Excel 2013 Class Video 40

DESCRIPTION Topics in this video: 1. Built-in Conditional Formatting. Conditional Formatting to cells: A logical test that comes out TRUE or FALSE. TRUE = get Formatting. FALSE = Not get Formatting. 2. Highlight Cell Rules: [Read More >>>]

### Excel Magic Trick 1097

DESCRIPTION See how to: (00:11) AND and OR Criteria. (01:14) Counting Formula with SUMPRODUCT and COUNTIFS and a function argument array operation (03:16) Adding Formula with SUMPRODUCT and SUMIFS and a function argument array operation [Read More >>>]

### Excel Magic Trick 1087

DESCRIPTION (08:00) Number Outside range with lower and upper hurdle. Numbers below the lower hurdle OR above the upper hurdle. (01:25) OR function. OR Criteria: only one TRUE is necessary for OR function to deliver [Read More >>>]

### Excel Magic Trick 1086

DESCRIPTION 3 Way Lookup Formula & Conditional Formatting, Date Criteria Mismatch & Merged Cell Trouble See how to:  (00:11 min) Create formula to lookup a value from a table with three criteria: INDEX and MATCH and [Read More >>>]