Microsoft Excel’s conditional formatting is a wonderful “automatic” feature that allows you to formats cells based on the value of those cells or the value of the formulas in those cells ...

Software engineer Chandoo shares some Excel conditional formatting tricks that make for good-looking and useful spreadsheets, like a Gantt chart.

Create additional conditional statements by highlighting the same cells, clicking the "Conditional Formatting" button again and making another selection. Save the workbook when you are finished.

[Conditional formatting] allows Excel to apply a defined format to cells that meet specific criteria. You can use a different background color, font color or border.

If the contents are a number-even if it is formatted as text by Excel-then the formula returns True, and the condition is met for the formatting.

Task Management You can use conditional formatting for task management scenarios in Excel, but the most common application for me is highlighting overdue tasks.