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

The first step to create a dynamic and interactive chart or diagram in Excel is to choose the right type of chart for your data and purpose. Excel offers a variety of chart types, such as column ...

With the dates selected (C3:C37), click the Home tab, click Conditional Formatting, and then choose New Rule from the dropdown (Figure B). Excel opens the new Conditional Formatting pane to the right.