### Highlight Duplicate Values

August 22, 2017

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 […]

### Highline Excel 2013 Class Video 48

August 11, 2017

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

### Excel Magic Trick 1307

July 24, 2017

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 […]

### Highline Excel 2013 Class Video 40

June 16, 2017

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: […]

### Dueling Excel 138

April 19, 2017

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. […]

### Dueling Excel 125

January 18, 2017

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 […]

### Excel Magic Trick 1245

November 7, 2016

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 Magic Trick 1230

September 15, 2016

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 […]

### Dueling Excel 100

September 7, 2016

Two Way Lookup Formula and Conditional Formatting! DESCRIPTION See Mr Excel and excelisfun use two methods to: 1. Mr Excel creates formula to do Two Way Lookup using INDEX and 2 MATCH functions 2. Excelisfun […]

### Dueling Excel 022

May 22, 2015

Conditional Formatting VBA or OFFSET? DESCRIPTION See Mr Excel use VBA code for Conditional formatting and see excelisfun use the OFFSET, MOD and ROWS functions to do Conditional Formatting. WORKBOOKS