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

How to create conditional formatting rules in Excel. Once the custom value formats exist, you can apply them using conditional formatting rules. Right now, the format is set to General.

In fact, you can customize all of the Conditional Formatting features using self-defined rules that are easy to create through Excel’s simple “walk-through” menus. We’ll cover that next.

Jazz up your Microsoft Excel workbook by creating conditional statements to visually represent trends within your data. The Conditional Format tool ... in Excel 2007. Edit your horizontal chart ...