Create an Excel Gantt Chart with Conditional Formatting [Excel Tip]

Category: Science/Tech | Posted by laraib 1531 days ago

Software engineer Chandoo shares some Excel conditional formatting tricks that make for good-looking and useful spreadsheets, like a Gantt chart. Conditional formatting makes a cell look a certain way based on its contents. A Gantt chart maps out deadlines within a project. Chandoo's Excel Gantt chart combines a calendar and to-do list to display what has to be completed when in a good-looking table layout. If you don't want to set up the sheet yourself, download an Excel Gantt chart template here. Here's more on using conditional formatting in your spreadsheets.
Learn Cool Microsoft Excel Conditional Formatting Tricks [Chandoo.org]