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

Excel’s conditional formatting is a powerful and versatile tool that lets you dynamically control formatting. For instance, you might implement a rule that displays a value in red if it reaches ...

Excel displays various options related to conditional formatting. Click Manage Rules. Excel displays the Conditional Formatting Rules Manager. The format you want copied should already be filled in.

Editor’s Note: To read more about spreadsheets, share a tip with other readers, or suggest a topic for Bill Jelen to cover in an upcoming column, click here to visit CFO.com’s Spreadsheet Tips Page.

At any time, you can edit, remove, manage, and run your conditional formatting rules in Excel. Here’s how. Open your Excel workbook and go to the Conditional Formatting menu.

Excel opens the new Conditional Formatting pane to the right. This pane is much easier to work with than the desktop interface. The Apply to Range is set to the range selected in step 1 by default.