If-Then rules allow you to create colorful business spreadsheets that do more than look pretty. Meaningful colors can help you and others identify data quickly, recognize trends and even spot ...

Q. Is there a way to color-code cells based on their cell content? For example, if cells state “Woman-Owned,” could those cells automatically become red and the cells that state “Large Company” ...

The Excel ribbon often forces you through multiple menus just to highlight important data. Hidden inside the Format Cells dialog is a syntax system that replaces several common formatting tasks like ...

PivotTable-aware conditional formatting ties rules to fields, so visuals persist even when you refresh, filter, or change layout.

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn’t. Using an old function and a matrix tames the problem. The article How to easily ...

This article provides step-by-step instructions for color customizing your drop-down list in Microsoft Excel. Color can be a powerful element in an Excel drop-down list, and it’s easier to add than ...

You may have used Excel for years without delving into Styles (or stylesheets), but they can make work easier and faster—and more visually appealing. In this feature, we’re going to go over Cell ...