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.

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

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 ...

2. Move The Legend. I don’t know why Excel positions the legend to the right of a chart by default. In most cases, it’s terribly awkward. I prefer to move the legend to the top or bottom of a ...