Dueling Excel

Dueling Excel 138

April 19, 2017 0

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

Dueling Excel 125

January 18, 2017 0

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 Is Fun

Excel Magic Trick 1245

November 7, 2016 0

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

September 15, 2016 0

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

Dueling Excel 100

September 7, 2016 0

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

Excel 2010 Tutorial For Beginners

Excel 2010 Tutorial For Beginners #9

May 9, 2015 0

DESCRIPTION More on Conditional Formatting, including removing conditional formats, highlight highest and lowest values and where to use the Icon Sets.

Excel Is Fun

Excel Magic Trick 1124

April 24, 2015 0

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 Is Fun

Excel Magic Trick 1119

April 19, 2015 0

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

Excel Is Fun

Excel Magic Trick 1106

March 4, 2015 0

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

Dueling Excel

Dueling Excel 014

February 25, 2015 0

DESCRIPTION See Mr Excel and excelisfun create formulas and Conditional Formatting that will display UP, DOWN, and SIDE arrows to indicate up or down for a list of numbers. See functions like: SIGN, IF, and […]