Conditional formatting makes a cell look a certain way based on its contents. A Gantt chart maps out deadlines within a project.

Manually combing through spreadsheets with large datasets can be a massive headache at times. Luckily, conditional formatting exists in Microsoft Excel specifically for this reason. This ...