Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. Learn the basics of this amazing feature.

Learn how to fix Excel conditional formatting issues with dynamic references, OFFSET function, and defined name method for clean spreadsheets ...

Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature.

To clear formatting from the selected cells in your workbook in Microsoft Excel, you can use Clear Formats, Keyboard shortcuts, Format Painter tool, etc.

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

Susan Harkins shows you how to visually identify holidays using Excel's conditional formatting feature.

In Microsoft Excel, individuals can make adjustments to their images by using features offered in the Adjust group on the Picture Format tab.

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

How to Paste From PDF Format to Excel. The PDF extension is a file format used by Adobe Reader, a free software program. However, PDF files are read-only, which means you cannot edit them.

Learn how to suppress or hide zero values in an Excel sheet using one of these quick and easy methods.