Excel Magic Trick 626: Time Gantt Chart -- Conditional Formatting & Data Validation Custom Formulas

Excel Magic Trick 626: Time Gantt Chart -- Conditional Formatting & Data Validation Custom Formulas Video Clips. Duration : 15.90 Mins.

See how to create a Gantt Chart to show the amount of time a projects takes during a day. Learn about: 1) Time Math 2) Conditional Formatting using the OR function in a logical formula to hide numbers 3) Data Validation using the Custom option with a logical formula that uses the ROUND functions and comparative operators to prevent too many hours being entered into formula. 4) Conditional Formatting using the AND function to create a Gantt chart in the cells. Related videos: Excel Magic Trick 565: Excel 2010 Daily Gantt Chart Excel Magic Trick 564: Daily Gantt Chart

Keywords: Excel, 2007, 2010, Time, Gantt, Chart, excelisfun, Mike, Gel, Girvin, Highline, Community, College, Conditional, Formatting, OR, function, logical, formula, hide, numbers, Data, Validation, Custom, AND, functions