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.