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

Tracking task or project completion in Excel becomes much easier when you use visual progress bars. Instead of scanning numbers, you can quickly see which tasks are on track, identify bottlenecks, and ...

If you really want to get your teeth into a challenge until the next ExcelZone KPI reporting tutorial appears, how would you go about combining the traffic light and data bar conditional formatting to ...

Reader John P. wins a copy of Charts and Graphs: Microsoft Excel 2010 from the MrExcel Library for his question: “Is there any way to Conditional Format a Chart Range? For example, I have a series of ...

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.

To add data bars, you select a range of numbers and then select Home, Conditional Formatting, Data Bars, choose a color. Excel 2007 offered six built-in colors. Excel 2010 offers six gradients and six ...