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

or copy a chart with conditional formatting, then use a paste style only selection from a drop down menu to apply the conditional formatting from your original chart to an existing chart in your ...

Select the cells you want to test, go to the “Home” tab, open the “Conditional Formatting” drop-down menu, select “Highlight ... Sparklines are single cell mini charts that visualize a set range of ...

To use conditional formatting in Excel 2007, click the cell to be formatted and click the Conditional Formatting button in the Styles section. In the drop-down menu, select Highlight Cell Rules, click ...

“Is there any way to Conditional Format a Chart Range? For example, I have a series of numbers in a Balance Sheet Model (Cash line) that are currently negative, thus when I chart, I make the bars red.