Excel Is Fun

Excel Magic Trick 1375

DESCRIPTION See how to: (00:01) How to Navigate to sections of this video (00:46) Introduction (01:32) What is an OR Logical Test using OR Criteria (02:30) Fundamental Problem with an OR Logical Test on Two [Read More >>>]

Excel Is Fun

Excel Magic Trick 1373

DESCRIPTION See how to Conditionally Format Every 5th Value and Extract Every 5th Value: 1. Introduction 2. Formula 1 for counting how many values will be extracted. ROWS & ROUNDDOWN Functions. 3. Formula 1 for [Read More >>>]

Excel Is Fun

Excel Magic Trick 1345

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1344

DESCRIPTION See how to use a formula to apply Conditional Formatting to apply formatting to an entire row based on a condition in an Excel Table. This video shows the Excel Table Feature which allows [Read More >>>]

Tricks & Tips

Highlight Duplicate Values

In this example I will show you how to highlight duplicate values in a column or row in less than 20 seconds. Here we have a list of names in Column A which contains some [Read More >>>]

Excel Is Fun

Excel Magic Trick 1307

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 [Read More >>>]

Dueling Excel

Dueling Excel 138

DESCRIPTION NETWORKDAYS.INTL Amazing New “Any Weekend” Argument Learn about amazing new feature in the NETWORKDAYS.INTL function for counting workdays that will accommodate any weekend scenario. See counting workdays and Conditional Formatting for weekdays or weekend. [Read More >>>]

Dueling Excel

Dueling Excel 125

DESCRIPTION Conditional Formatting Date Four Days Old & Not Paid See Mr Excel and excelisfun use two methods to Conditional Formatting Date That is Four Or More Days Old & Not Paid 1. Conditional Formatting [Read More >>>]

Excel Is Fun

Excel Magic Trick 1245

DESCRIPTION Merry Christmas Tree Fun In Excel RAND Function and Conditional Formatting See how to create a Christmas Tree in Excel with the RAND function and Conditional Formatting and the F9 key. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1230

DESCRIPTION Conditional Formatting: Highlight Table with Colour When Name Selected Learn how to create a Logical Formula to colour a table when a name is selected from a drop down: (00:13) Problem Overview (00:35) Keyboard [Read More >>>]