Download Excel Files:
Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MikeGelGirvinYouTubeExcelMagicTricks91-99.xls
Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MikeGelGirvinYouTubeExcelMagicTricks91-99Finished.xls
Full Page With All File Links: http://people.highline.edu/mgirvin/excelisfun.htm
See how to use Conditional Formatting to create a Gantt Cell Chart. See how to use Conditional Formatting to highlight a range of cells that space a certain Time Frame.
Formula and functions
Source