Main Profile

At A Glance

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

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
Length: 15:54

Contact

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

Want more info about Excel Magic Trick 626: Time Gantt Chart -- Conditional Formatting & Data Validation Custom Formulas? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question