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

Conditional formatting can help you get the information you need from data. For example, suppose you would like to know how many students in your class received an above-average score on a recent ...

Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. Learn the basics of this amazing feature.

Excel for the web now supports conditional formatting, and the interface is easier to use than the desktop edition. Susan Harkins shows you how to use it.

As an example, suppose you have an Excel workbook that contains each student’s numerical course grades, but you would like a visual way to differentiate each student’s letter grade (A, B, C, D, or F).

Visualizing task status is crucial for effective project management, and Excel's conditional formatting provides a powerful way to achieve this. Suppose you are managing a website redesign project.

Excel gives you complete control over the conditional formatting in your workbook, allowing you to customize the criteria, style and color.

One way to get around this issue is to convert the Excel table to a range by selecting any cell in the table, and clicking ...