Where conditional formatting is concerned, this is often the case. In this Excel tutorial, I’ll show you how to apply conditional formatting to a filtered PivotTable in Excel.

Excel's conditional formatting lets you customize how your data displays, from changing colors and shading to adding icons and more. Here's how it works.

How to Format Debits and Credits in Excel. When you use Microsoft Excel to analyze your company's data, you want to spot trends, successes and problems at a glance. Before you dive into an in ...

In this tutorial, I’ll show you how to add a validation control and then add conditional formatting to include visual cues for the drop-down.

The error "Too many different cell formats" in Excel occurs when the data in Excel exceeds the formatting limit. Here are some solutions to try.

Charts and sparklines are powerful data visualization tools in Excel. Here’s a guide to the most popular chart types in Excel and how to best use them.

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

In this story, we’ll get you up and running with tables in Excel, from creating and formatting them to performing calculations on their data.